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?

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 <[email protected]>, [email protected] 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?
>
>
>
>