secondary axis on chart

[Guest]

I am trying to do a chart with a secondary axis. I am using excel 2000 and I
can't find the secondary axis. I see under the axes tab only a primary
axis...any suggestions?

 

[David Biddulph]

I am trying to do a chart with a secondary axis. I am using excel 2000 and
I
can't find the secondary axis. I see under the axes tab only a primary
axis...any suggestions?

"Format data series" for the series which you wish to use the secondary
axis, go to the axis tab, select secondary axis. [You will, of course, need
at least two series on the graph to allow a secondary axis; if you've only
got one series you can use a dummy as a second one.]