Excel issue

Copper Contributor

Hello everyone, I have been given a spreadsheet with data on students grades and ive been asked to ''create a pie chart of the overall grades achieved''. The grades are in letter form, ive watched a video on how to do this does but I'm still struggling ,does anyone have advice for me to do it. If you do please help because I'm quite stuck.

3 Replies

Hey @Curt20192 

 

Try This

 

What I did was make another range in which I listed all the type of grades the students can achieve (Eg: A,B,C,D,E)

Then I counted how many students got that grade using the COUNTIF function:

=COUNTIF($B$1:$B$20,D4), where $B$1:$B$20 refers to the range of letter grades for each student and D4 to the type of letter grade they can achieve.

 

You can then make a pie chart out of this.

Checkout my file that I have Attatched to get a better Idea

@Excel_World_Champion 

Thankyou.

 

@Curt20192 

 

No worries!