Problem with secondary y axis

  • Thread starter Thread starter Leslie
  • Start date Start date
L

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.
 
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
 
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.
 
Back
Top