Thread
:
Can I add a secondary (x) axis to the chart in Excel?
View Single Post
#
4
Tushar Mehta
Posts: n/a
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
In article ,
says...
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
"Tushar Mehta" wrote:
If I understand you correctly, you want a single chart with 2 sets of
axes. If so, you can simulate the effect. Visit
http://www.tushar-mehta.com/excel/tips/index.html
, scroll down and
click on 'Singe chart with dual axis'
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
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.
Reply With Quote