Create 2-Axis Combination Chart XL 2007

[t2fulham]

In Excel 2007, there does not appear to be a chart type for combination
charts. I an trying to create a line-bar chart with the line on the left
vertical axis and the bar on the right vertical axis.

 

[Shane Devenshire]

Hi,

Microsoft has remove the Custom Types option, however you can still do it
manually.

1. Create a line of column chart with your two data sets.
2. Right-click one of the series and choose Format Data Series and on the
Series Options tab check Secondary. Click Close.
3. With one of the series selected choose Chart Tools, Design, Change Chart
Type and pick a line.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[t2fulham]

Spectacular. Not exactly intuitive, but just the ticket.
Thanks.