Secondary X- and Y- Axes

G

Guest

I want to plot one series on a primary x and y axis and then another on a secondary x and y axis. My goal is to adjust the scale of all of the axis until the two series overlap. I noticed that you can label both a secondary x and y axis but I can't figure out how to plot a series on both a secondary x and y axis. I am using Excel 2000. Any ideas?
 
A

Andy Pope

Hi Allison,

Select the data series that you want to place on the seconadry axes.
Use CTRL+1 to display the format dialog box and select the axis tab so
you can check the secondary axis.
To get series to use the secondary x axis you need to right click the
chart and choose Chart Options. On the axis tab you can now enable the
secondary x axis.

Cheers
Andy
 

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

X-Axis Appearing in Plot Area 2
Can't get the x-axis to cross at value 0 for both y-axes 3
Chart distorts secondary axis when the x-axis is logarithmic 5
How do I put words as the Y axis values? 0
Using the full width of an Excel chart with two Y-axes 2
Moving overlapping bars forwards and backwards 1
extra info is showing up in my secondary x axis, I can't get rid o 1
Switch x and y axes 3

Top