Forum Discussion

Curt20192's avatar
Curt20192
Copper Contributor
Jul 06, 2019

Excel issue

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.

excel

3 Replies

  • Excel_World_Champion's avatar
    Excel_World_Champion
    Brass Contributor
    Jul 06, 2019

    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

Resources