Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ecanbay
 
Posts: n/a
Default Can I add a secondary (x) axis to the chart in Excel?

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.
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

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.

  #3   Report Post  
ecanbay
 
Posts: n/a
Default

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
Two bars for a Chart with a Secondary Axis GregBausman Charts and Charting in Excel 3 March 1st 05 11:03 PM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM
Secondary Axis iris Charts and Charting in Excel 1 December 31st 04 05:55 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 01:48 PM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"