Forum Discussion

E_P_108's avatar
E_P_108
Copper Contributor
Sep 15, 2023

Excel graph: Grouped Columns graph with z axis

Hi, 

 

I need to plot  a grouped graph with y axis (Continuous Scales : Scores of Students), X-axis (categories: Males, Females and ALL -grouped as bars for each subject); z axis (Scoring Categories for Y axis as below.

 MaleFemalesAll 
Maths565554Excellent: Scores 81-100
Science747273Very Good:71-80
English545452Good:61-70 
French494950Average:51-60
Music585857Fail:0 to 50

 

I want background of each level of the 5 scores with separate colours on z axis (interval axis) labelled as the 5 levels above. Example of the graph required and excel spreadsheet attached. 

Thanks

 

No RepliesBe the first to reply

Resources