Excel charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/
_______
 
Back
Top