I'm trying to create an x y scatter chart with 2 Y axis. I follow the
instructions on the web site, but I don't get the option in the format
pull-down. I'm beginning to think Excel 2000 doesn't support the 2 Y axis
option. Am I nuts?

Cathy,

To get the second Y-axis, double-click on one of the points on the series
that you want to chart on the second axis. In the Format Data Series dialog
box, go to the Axis tab. Choose the "Plot series on secondary axis" option.

----
Regards,
John Mansfield
http://www.pdbook.com


"Cathy1114" wrote:

I'm trying to create an x y scatter chart with 2 Y axis. I follow the
instructions on the web site, but I don't get the option in the format
pull-down. I'm beginning to think Excel 2000 doesn't support the 2 Y axis
option. Am I nuts?

Cathy -

Don't forget, you need at least two series before Excel will allow a secondary axis.

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

John Mansfield wrote:

Cathy,

To get the second Y-axis, double-click on one of the points on the series
that you want to chart on the second axis. In the Format Data Series dialog
box, go to the Axis tab. Choose the "Plot series on secondary axis" option.

----
Regards,
John Mansfield
http://www.pdbook.com


"Cathy1114" wrote:


I'm trying to create an x y scatter chart with 2 Y axis. I follow the
instructions on the web site, but I don't get the option in the format
pull-down. I'm beginning to think Excel 2000 doesn't support the 2 Y axis
option. Am I nuts?