Secondary X axis

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
 
T

Tushar Mehta

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
 
J

Jon Peltier

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
 

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

Primary X axis to Secondary X axis 1
Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
Make Y-axis values correspond to x- axis value 1
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
Coordinate secondary y axis to primary y axis 2
simple chart 0

Top