Problem with secondary y axis

[Leslie]

Using Excel 2002, I've created a column chart with 9 columns. Of those
columns, 6 are simple and 3 are stacked. The 3rd of the 3 stacked columns
is the last column on the chart reading from left to right. That column's
value is much greater than those of the other 8 columns. The others have
values ranging from 2.7 to 12, while the last column's value is 51.8.

Having read about three alternative methods for dealing with the problem
(logarithmic scale; broken y axis; and secondary y axis), I would like to
use the secondary y axis method for the last column only. I've read what I
could find on the Web about creating a secondary axis in a column chart,
including Jon Peltier's document "Column Chart on Two Axes". I tried to
adapt his method to my situation, where the column concerned is a stacked
one, but I haven't been able to get it to work. Doing the best I could, my
stacked column wouldn't stay stacked. Instead, it splt into its 3 component
series.

I'd welcome any suggestion as to how to proceed now.

 

[Debra Dalgleish]

Plot all three series in the third stacked column on the secondary axis.
Then, select on of the series, and choose Chart>Chart Type
Select the Stacked Column subtype, click OK

 

[Guest]

Thank you very much for your help, Debra.

I think I was overcomplicating what I had to do. I inferred from things I'd read that any time you try to use a secondary y axis in a column chart, the column concerned will interfere with the display of the column(s) using the primary y axis. Obviously, that's not so.