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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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
Chart distorts secondary axis when the x-axis is logarithmic 5
how to switch the primary and secondary Y axis to opposite chart s 2
Primary X axis to Secondary X axis 1
Can't get the x-axis to cross at value 0 for both y-axes 3
Excel 2007: X-axis labeling 1
Secondary Axis 1

Back
Top