Ken -
As long as you have two series in a chart, you can have primary and
secondary axes. To put a series onto the secondary axes, double click on
it, select the Axis tab, and select the Secondary option.
Usually Excel underestimates your intelligence, and sticks you with just
a secondary Y axis. But you can exercise your control over Excel in this
way. Right click the chart, and choose chart options. Click on the Axes
tab, and select the combination of primary and secondary X and Y axes
you want.
If you have all four axes in use, you cannot mix and match your series.
That is, if a series uses the primary X axis, it also must use the
primary Y axis.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
