I cannot make charts with two Y axes anymore

J

jimbo

Now that I have Excel 2007, I cannot find the same template as I had
in the previous versions of Excel. I must be missing something.
Lines on 2 axes used to be included on the Custom Types menu, but I
cannot find it anywhere on the 2007 chart menu.
 
A

Andy Pope

Hi,

Combination charts are not offered as default chart types in xl2007, which
is good.
You will need to format the chart your self. Create the chart as a 2 series
line chart and then select the series you want displayed on the secondary
axis.
Once selected use the Format dialog to select Series Options and change Plot
Series On to Secondary axis.

Cheers
Andy
 
Top