2 graphs in one chart

[newboy 21]

Is it possible to have 1 chart that has the date along the bottom, Series 1
up the left and Series 2 up the right?
The idea is to have a graph of 2 totaly different scales over the same time
period?

 

[Andy Pope]

Hi,

Yes, create the chart with both data series. Select one of the series
and right click. Choose Format selected series and on the Scale tab
click the Secondary Axis option.

Cheers
Andy

 

[Barb Reinhardt]

Plot your data on as an X-Y scatter chart.
Select the series that you want on the secondary scale.
Format Data Series -> Axis ... Select Secondary Axis

 

[Jon Peltier]

This works with other chart types, not just XY Scatter. Line, Column, Area,
Combinations as well.

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