Secondary X- and Y- Axes

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top