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
|
|||
|
|||
2 Axis chart and scaling
Hi,
I want to create a 2 axis chart. The 2 y axes have a relationship two each other. Thus if I change the scale on one, I want the other to change to keep the correct relationship. Can this be done? |
#2
|
|||
|
|||
Yes, though you will have to calculate and set the axis scale values by
hand. See Excel Tips http://www.tushar-mehta.com/excel/tips/index.html Scroll down and check the pdf file '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... Hi, I want to create a 2 axis chart. The 2 y axes have a relationship two each other. Thus if I change the scale on one, I want the other to change to keep the correct relationship. Can this be done? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Scaling a chart that has been dynamically created in vb | Mark | Charts and Charting | 3 | May 27th, 2005 08:16 PM |
Varying axis scaling | jeffnoll | Charts and Charting | 2 | February 18th, 2005 02:02 AM |
Dual axis with Bar chart + two series : is it possible ?? | lOURY | Charts and Charting | 3 | February 20th, 2004 03:55 PM |
Is there any way to stop chart imagery from scaling randomly? | how_D | Charts and Charting | 0 | October 21st, 2003 06:56 PM |