Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel comparison pie chart help
Name: tonyme7 Date: February 15, 2006 at 18:02:12 Pacific OS: xp pro CPU/Ram: 1ghz athlon 512mb pc 133 Product: msi
Comment:
Hello, I am trying to make a pie chart that reflects the cities that we receive the most complaints from. It looks a little like this. It has the customer name, city and ph # EXAMPLE Gary & Shelly Jones Avondale 602-555-6999 MIke Garrison Phoenix 602-555-3336
We don't need to know who or any of that, we just want to know how many complaints we receive from each city. We have about 6 cities on the list.
How do I make a pie chart based on that information?
Name: wizard-fred Date: February 15, 2006 at 21:17:45 Pacific
Reply:
You would have to get the number of complaints per city. If you can do it without disturbing the information sorting by city would do it. Then a pivot table will get you the number per city. Which should be enough to make the chart.
Summary: Hi there I'm having a problem making a graph with an Excel sheet. It is made up of information based on two types of customers. So in the Type column there is C (for Corporate) and P (for Personal)....
Summary: hi just doing something similar for someone, i just copied (right click) the whole chart from one tab page to another, dont know if thats right but it worked. small hijack of your post but seeing as i...
0 
