Forum Discussion
E_P_108
Sep 15, 2023Copper Contributor
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.
Male | Females | All | ||
Maths | 56 | 55 | 54 | Excellent: Scores 81-100 |
Science | 74 | 72 | 73 | Very Good:71-80 |
English | 54 | 54 | 52 | Good:61-70 |
French | 49 | 49 | 50 | Average:51-60 |
Music | 58 | 58 | 57 | Fail: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