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.

ribboninsertchart 

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

combinationlinecolumn01

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.

combinationlinecolumn2003

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

_____________

___________________

3 comments to Create a Line Column Chart on 2 Axes in Excel 2010

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>