2 graphs in one chart

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

Guest

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