| Home |
| Search |
| Today's Posts |
|
|
|
#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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scaling a chart that has been dynamically created in vb | Charts and Charting in Excel | |||
| Log Chart Scale Problem | Charts and Charting in Excel | |||
| Varying axis scaling | Charts and Charting in Excel | |||
| Auto Scaling of Y-axis | Charts and Charting in Excel | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Hybrid Mode
