Create a Pie Chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a spreadsheet with Demographic information on it (Name, Address,
City, State, etc.) I want to create a pie chart that shows how many people
on the sheet are from which cities. So the title of the chart will be Cities
and the chart should have pie peices, one for each different city that's in
the list along with the percent of the entries are in eash city, depicted as
a percentage peice of that pie. I do not have predefined lables as these
will be different and entered as they come in. How do I do this? I'm new to
excel and don't know what to put in the feilds in the Chart Wizard to get it
to do what I'm trying to do. Any help would be delightful. Thanks in
advance.
 
I think the easiest way to get what you want is by using countif
Let's say that your city names are in the D column,
use some blank cells to hold this formula
=COUNTIF(D:D,"New York")
=COUNTIF(D:D,"Los Angeles")
etc.
now create a pie chart with these cells as the data series. I think
this is what you are looking for.
 
You are best off creating a PivotTable and an associated PivotChart. Check
Data | PivotTable and PivotChart Report...

In the PivotTable, put the City as the row field and also as the data field.
XL will automatically use COUNT(City) as the data field. That will give you
what you want.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top