Can I add a secondary (x) axis to the chart in Excel?

G

Guest

I easily can add X axis to the excel chart. However, what I need is that I
need to add both a X and Y axis. The reason is that I have charts in SI units
and I want to also show the US Customary units in the same chart. The
original X and Y axes are at the bottom and left. The new axes will be on the
top and right.
 
G

Guest

Dear Tushar Mehta,
Thank you for your response. However, my question was simply adding a
secondary X axis. I have figured out that adding a secondary Y axis is
simple. However, How can I add both a secondary X and a secondary Y axis to
an excel chart with XY scatter type of series.

Best Regards.

- Erdem
 
T

Tushar Mehta

Once you have the secondary y-axis, select the chart then select Chart
| Chart Options... | Axes tab. In there check on the option for the
Secondary x axis.

--
Regards,

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

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

Horizontal axis to the bottom 1
extra info is showing up in my secondary x axis, I can't get rid o 1
how to switch the primary and secondary Y axis to opposite chart s 2
Chart distorts secondary axis when the x-axis is logarithmic 5
Primary X axis to Secondary X axis 1
Can't get the x-axis to cross at value 0 for both y-axes 3
Swap Y-Axis numbers 3
three y axes 2

Top