If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stacked Bar Chart with Secondary Axis | Benjamin B | Charts and Charting | 7 | May 15th, 2005 04:00 AM |
How do I set permanent secondary axis in PivotTable chart? | Microlong | Charts and Charting | 3 | January 8th, 2005 03:54 AM |
How do I set up a bar chart with a secondary axis? | Buh | Charts and Charting | 1 | September 8th, 2004 06:35 PM |
Bar chart with secondary axis | George Wilson | Charts and Charting | 1 | September 1st, 2004 05:14 PM |
P & V chart: Secondary X axis gradient (again) | wlotto | Charts and Charting | 9 | March 15th, 2004 05:26 PM |