Pie Chart Labeling

Tantrum31 · #1 08-12-2008, 05:31 PM

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.

se1429 · #2 08-13-2008, 02:16 AM

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.

**Andy Pope** · #3 08-13-2008, 07:16 AM

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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)