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

  • Thread starter max the driller
  • Start date
M

max the driller

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

Debra Dalgleish

Right-click on one of the series, and select Format Data Series
Select the Axis tab
Select Secondary Axis, click OK
 
J

Jon Peltier

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