Adding a second x-axis to an ExCel chart

  • Thread starter Thread starter Selaretus
  • Start date Start date
S

Selaretus

How can I add a second x-axis to an ExCel chart? Specifically, I wan
one with
values running high to low and the second running low to high for
Tilman plot.
Thanks for the help!!

Cheers!

Dirk
(e-mail address removed)
 
Dirk -

You need at least two series, one for primary and one for secondary axes. Double
click one series, and on the Axis tab, select Secondary. This produces a secondary Y
axis. Right click the chart, choose Chart Options from the Chart menu, and on the
Axes tab, check the secondary X axis box, and if desired, uncheck the secondary Y
axis box.

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