Secondary X axis

  • Thread starter Thread starter Rohan
  • Start date Start date
R

Rohan

I was wondering if it is possible to have a secondary X
axis so i can have two variables with different units on
the X axis. Or alternatively, but preferably not, if I
used a secondary Y axis is there a way to rotate the
chart???
Thanks in advance,
Rohan
 
To add a secondary x-axis, you need a 2nd series. Once you add that,
select the chart, then Chart | Chart Options... | Axes tab.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Rohan -

When you've sent a series to the secondary axis group, Excel just gives
you a secondary Y axis. Right click the chart, select Chart Options
from the pop up menu, and click on the Axes tab. From here you can
select any combination of primary and secondary axes.

- Jon
 
Back
Top