PIE CHART HELP!!!!

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
I've lost my mind. I have a list of student names and the grade they've earned in class (A, B, C, D or F). I want a pie chart to display the percentage of each letter grade. How do I do this? My data is in 2 columns. Student names in col A and the letter grade in col B. Thanks a million!!!
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Enter the grades A to F in C1:C5. In D1 enter:

=COUNTIF(B:B,C1)

and copy down.

Plot C1:D5 as a pie chart, with date labels as percent.
 

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587
PIE CHARTS ARE EVIL!

The one thing I hate the most out of Excel are Pie Charts. They are SO DIFFICULT to keep the same size!!! I hate them, I hate them, I hate them, I hate them, I hate them, I hate them, I hate them, I hate them!
:x

I hope they severely improved their usefulness in the new version of Excel (even tho we won't get it for another 3 years here at work).
 

Watch MrExcel Video

Forum statistics

Threads
1,118,388
Messages
5,571,842
Members
412,420
Latest member
grace_abar
Top