Charting cells with the same data in them to one chart bar

  • Thread starter Thread starter Jason Spence
  • Start date Start date
J

Jason Spence

I have several cells that all have a "total" of 1 adn
like 5 with different totals, I want a way for the pie
chart (or what ever chart) to graph the totals and all
the ones with "1" to come up as 1 pie slice with all the
data listed.

20037 Washington 1
30013 Conyers 1
30022 Alpharetta 1
30052 Loganville 1
30064 Marietta 1
30068 Marietta 1
30076 Roswell 1
30084 Tucker 1
30088 Stone Mountain 1
30092 Norcross 1
30108 Bowdon 1
30168 Austell 1
30263 Newnan 1
30306 Atlanta 1
30316 Atlanta 1
30318 Atlanta 1
30327 Atlanta 1
30329 Atlanta 1
30341 Atlanta 1
30345 Atlanta 1
33626 Tampa 1
35226 Birmingham 1
53202 Milwaukee 1
94526 Danville 1
 
Do you mean you just want to show totals for each town? Put labels in
the row above the data, like "Zip", "City", and "No." Select the data,
and make a pivot table (Data Menu). Drag the City field to the Row area
and the No. field to the Data area. Excel automatically fills the data
column with Sum of No. The pivot table looks like this:

Sum of No
city Total
Alpharetta 1
Atlanta 7
Austell 1
Birmingham 1
Bowdon 1
Conyers 1
Danville 1
Loganville 1
Marietta 2
Milwaukee 1
Newnan 1
Norcross 1
Roswell 1
Stone Mountain 1
Tampa 1
Tucker 1
Washington 1
Grand Total 24

Make a pivot chart, then use Chart Type from the Chart menu to turn it
into a Pie chart. Better yet, make a real chart: Select a cell away from
the pivot table and start the chart wizard. Choose a Pie in step 1, and
in step 2, click on the Series tab, and select the range with the city
names for X and the sums as Y.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top