I am trying to make a pie chart containing the number of retail employees per city. There are two columns I am trying to use. The first contains the name of the city, and the second the number of employees. Since each city has different zones, there are multiple rows that have the same city name. When I make the pie chart, it creates a slice for each zone rather than each city. Is there a way to merge these zones together? I attached an example.
Hi,
You can create a pivot table from your data in a new worksheet. This will summarize your data by city. I.e. one row for each city. Then you can create a pie chart from that summary.
Regards.
Welcome to: http://www.exceldigest.com/myblog/
"Excel help for the rest of us"
Charts do not summarise your data you have to do that.
Either use se1429's suggestion of a pivot table and chart or COUNTIF formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks