How do I make a line-column 2-axis chart in Excel 2007?

**shadestreet** · 04-08-2009, 03:05 PM

I don't see this as a chart type option anymore in Excel 2007, any ideas how to make a Line-Column 2-axis chart in Excel 2007?

Used to be one of the "Special" or "Custom" chart type selections in Excel 2003 and earlier. Help!

**Andy Pope** · 04-09-2009, 05:13 AM

xl2007 does not have the built-in custom type charts anymore.

But you can make you own quite easily.
Start by createing a Line chart which includes both series.
Select one of the series and change it's chart type to column
For that same series use the Format dialog to change it to plot on the Secondary axis.