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

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

Finding asymptote equation and how to draw them in excel 0
Primary X axis to Secondary X axis 1
Scatter chart with categories on x-Axis 2
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
extra info is showing up in my secondary x axis, I can't get rid o 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Additional secondary axis scales 0
Secondary Axis 1

Top