Multiple stacked bar w/ 2 y-axis

**Chez525** · 11-23-2009, 11:41 PM

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.)

**teylyn** · 11-23-2009, 11:56 PM

I think you'd need to trick it ...

You can only plot a complete series on a secondary axis.

In the attached I've created two separate charts, sized them just so and let them overlap. Looks like the real deal, though

does that help?

**Andy Pope** · 11-24-2009, 05:42 AM

It is possible to do in 1 chart, although you need to be careful the information is not mis-read.

The series on the secondary axis have been formatted to match the primary axis series.
You can delete the additional series from the legend.