I'd like to graph multiple stacked bar charts on a single graph but because of the scale of one of the stacked bar charts, I need to place it on the secondary axis so the smaller stacked bar charts are still discernable.
Say for example I want to graph a school district grades' that look like-
Grades Elem 1 Elem 2 Elem 3 Elem 4 Jr High 1 Jr High 2 High
A 15 15 15 15 15 15 120
B 30 30 30 30 30 30 120
C 10 10 10 10 10 10 120
D 8 8 8 8 8 8 28
F 5 5 5 5 5 5 20
So I'd like to graph all of the schools on one chart, but the High school should be on the secondary y-axis because of the scale.
(I know its possible to do this graph as a clustered graph, but to save space, on a dashboard for instance, I'd prefer to keep it as a stacked column.)
Bookmarks