Jul 06 2019 11:37 AM
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.
Jul 06 2019 12:03 PM
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