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?