Home

Excel issue

%3CLINGO-SUB%20id%3D%22lingo-sub-740971%22%20slang%3D%22en-US%22%3EExcel%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740971%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20I%20have%20been%20given%20a%20spreadsheet%20with%20data%20on%20students%20grades%20and%20ive%20been%20asked%20to%20''create%20a%20pie%20chart%20of%20the%20overall%20grades%20achieved''.%20The%20grades%20are%20in%20letter%20form%2C%20ive%20watched%20a%20video%20on%20how%20to%20do%20this%20does%20but%20I'm%20still%20struggling%20%2Cdoes%20anyone%20have%20advice%20for%20me%20to%20do%20it.%20If%20you%20do%20please%20help%20because%20I'm%20quite%20stuck.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740971%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740988%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740988%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372087%22%20target%3D%22_blank%22%3E%40Curt20192%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20This%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20did%20was%20make%20another%20range%20in%20which%20I%20listed%20all%20the%20type%20of%20grades%20the%20students%20can%20achieve%20(Eg%3A%20A%2CB%2CC%2CD%2CE)%3C%2FP%3E%3CP%3EThen%20I%20counted%20how%20many%20students%20got%20that%20grade%20using%20the%20COUNTIF%20function%3A%3C%2FP%3E%3CP%3E%3DCOUNTIF(%24B%241%3A%24B%2420%2CD4)%2C%20where%26nbsp%3B%24B%241%3A%24B%2420%20refers%20to%20the%20range%20of%20letter%20grades%20for%20each%20student%20and%20D4%20to%20the%20type%20of%20letter%20grade%20they%20can%20achieve.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20then%20make%20a%20pie%20chart%20out%20of%20this.%3C%2FP%3E%3CP%3ECheckout%20my%20file%20that%20I%20have%20Attatched%20to%20get%20a%20better%20Idea%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740990%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740990%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367553%22%20target%3D%22_blank%22%3E%40Excel_World_Champion%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThankyou.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740991%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372087%22%20target%3D%22_blank%22%3E%40Curt20192%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20worries!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Curt20192
New 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!

Related Conversations