Create 2-Axis Combination Chart XL 2007

  • Thread starter Thread starter t2fulham
  • Start date Start date
T

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.
 
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
 
Back
Top