2 Axis chart and scaling

[Sheldon]

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?

 

[Tushar Mehta]

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