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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

three y axes 2
Excel 2007 Bar and Line chart on 2 Axes 3
how to switch the primary and secondary Y axis to opposite chart s 2
pareto chart in Excel 2007? 1
dual y-axis align grid, drop line to y axis, add-ins 1
Switch x and y axes 3
Swap Y-Axis numbers 3
2 y-axes PivotChart 1

Top