Excel charts

[David Edwards]

How do I create a chart with a different scales on the left and right hand
sides.
i.e. Dollar values on the left and interest rates on the right?

Thanks

 

[Jon Peltier]

David -

Here's what I just told Suzanne:

Plot your two series (you need at least two series before Excel will allow you
secondary axes). Double click on one of them, and on the Series tab, check
Secondary. This gives you by default just a secondary Y axis. To get a secondary X
axis in addition to or instead of the secondary Y axis, select Chart Options from
the Chart menu, and on the Axes tab, check the combination of axes that you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______