Excel Help/Pie charts

[LaRue Medlin]

I have approx 500 line entries on my work spreadsheet and need to make a pie chart from it. I:wacko: can't get it to work, so could someone help. I need it broken down by location(city) so I know where most of my work is. In my library is a sample of my spread sheet. Thanks...

 

[Gerald Pierce]

I did a bar graph by mistake instead of a pie chart but I sent it to you in email..... you will get the idea. Use the countif function and it should work for you.....





Gerry

 

[LaRue Medlin]

thanks Gerry, I'll see what I can do:blink: