lines on 2 axis
 

This works fine if you only plot 2 series,
But how do you plot 3 series, 2 on Y axis and the 1 on the other Y axis ??
??ian

Hi,

You can select a series and change the axis it is plotted on, depending
on the combination of chart types.
Check the Axis tab on the Format dialog that is displayed after double
clicking the data series.

Cheers
Andy

ias wrote:
This works fine if you only plot 2 series,
But how do you plot 3 series, 2 on Y axis and the 1 on the other Y axis ??
??ian

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info