Create a Line Column Chart on 2 Axes in Excel 2010

When you create a chart in Excel 2010, you can select a chart type on the Ribbon’s Insert tab.


For some charts, instead of selecting one type, you might like to combine two different chart types, like the line-column chart shown below.


The Old Chart Wizard

In Excel 2003 and earlier versions, there were combination chart types available in the Chart Wizard. You could click on one of those, to quickly create your combination chart.


In Excel 2010 and Excel 2007, these combination charts, such as Line-Column and Line-Column on 2 Axes, aren’t available in the Chart Type window. However, you can easily create your own combination charts, by creating a chart, and then changing a specific series’ chart type.

Watch the Combination Chart Video

Watch this video to see the steps for creating a line-column chart on 2 Axes, in the newer versions of Excel.

Download the Sample File

To download the sample file, and to see the written instructions, please visit my Contextures website: Line-Column Combo Chart