In order to show the secondary Y axis, you need to plot at least one series on the
secondary axis. It's tricky with column charts, so I would add a series as a line
chart series and assign that to the secondary axis.
On the Chart menu, go to Source Data, and on the Series tab, click Add. Select some
reasonable data for the Y values and click OK. Select this new series, and on the
Chart menu, use Chart Type to change it to a line series. Double click the line, and
on the Axis tab, select Secondary, then on the Patterns tab, choose None for Markers
and for Line to hide the series. If you choose data wisely for the added series, it
will span the same data range, and Excel's auto scaling will generate the same axis
parameters for both sides. Otherwise you'll have to manually adjust the axes to show
the same scales.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
