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
 
Back
Top