How do I get a second Y axis in Excel 2000

C

Cathy1114

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?
 
J

John Mansfield

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.
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Excel 2007: X-axis labeling 1
How do I adjust marker spacing in Excel scatter plot? 1
X Y (Scatter) Chart EXCEL 2007 1
Using the full width of an Excel chart with two Y-axes 2

Top