How do I add a secondary x axis to an excel 2002 chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to show 2 value sets on different scales which vary with depth in the
ground. Naturally the depth should be shown on the y axis and the values
shown on the x axis. I therefore need to be able to add a secondary x axis.
Can anybody help please.
 
Right-click on one of the series, and select Format Data Series
Select the Axis tab
Select Secondary Axis, click OK
 
One more step to get the secondary X axis. Choose Chart Options from the Chart menu,
and on the Axes tab, check the Secondary X box.

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