My web page was written based on Excel 97. The secondary Y axis was
never explicitly scaled for the data. A maximum value between 3 and 8
for a typical chart size just happened to display properly with the
default scale settings.

In earlier version of Excel (97 and maybe 2000), when you add the
scatter series, only the secondary X axis appears automatically, not the
secondary Y axis. To display this axis, go to Chart Options on the Chart
menu, click on the Axes tab, and check the Secondary Y Axis box.

In Excel 2003 (and presumably 2002), changing the second series to a
Scatter type adds both secondary axes. This is among the very few
charting enhancements that has come along since Excel 97; another is the
expanded options for data labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Andy Pope wrote:

Have you unchecked the crosses at maximum AND In reverse order flags for
the main Y axis?

mjamromi wrote:

Andy,

Thanks for your reply. The one thing I seem to be unable to do is get
the secondary Y axis to display. I've turned it off and on again using
Chart Options, but I can't get it to show. How do I get it to work?