I cannot make charts with two Y axes anymore

  • Thread starter Thread starter jimbo
  • Start date Start date
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.
 
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
 
Back
Top