Creating a Pie Chart
Posted by Karen on January 18, 2001 4:03 PM
I need to create a pie chart with labels, but am having some difficulties. I actually need two different charts. In Column A, Cells A2:A23 are the programs that we have. In Row 1, Cells B1:Q1 are the counties that we serve. In the cells between (B2:Q23) are the number of people that were served per program, per county. I need a pie chart for the number of people served per county and one for the number of people served per program. As for the labels, the pie chart per county needs to have the county name per corresponding slice of pie, and the same goes for program. I have put a formula in cells R2:R23 and B23:Q23 to calculate totals. For some reason, it's just not coming out right. Any suggestions or help? I'm sure this is a simple thing to do, but I'm fairly new to Excel and am having trouble getting it to work.