You don't add a secondary axis. You format a series to be plotted on the
secondary axis, and this cues Excel to add the axis. Right click on a
series, choose Format Series, and on the Axis tab (2003) or on the main tab
(2007), select the secondary option.
To start out with labels (assuming the two series Y data are in columns B
and C) put the labels in the row above the data in columns B and C, and
leave the corresponding cell in column A blank. Select the data including
this first row, and Excel adds the labels as series names.
To add series names to existing series, select the series and look in the
formula bar. If there are no labels already, the formula will start like
=SERIES(,
Click between the opening paren and the comma, and type the name you want in
quotes. Or click between the opening paren and the comma, then click on the
cell that contains the series name, so the formula will begin something
like:
=SERIES("First Series",
or
=SERIES(Sheet1!$B$1,
Items in the formula after the first column are the X values, the Y values,
and the plot order of the series. For more info:
http://peltiertech.com/Excel/ChartsHowTo/ChartSeriesFormula.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______