Site icon Professor Excel

Combine Two Chart Types in Excel: How to Create Combo-Charts?

combine, chart, types, excel

Creating charts in Excel is quite easy: Select the data and choose your desired chart type on the ‘Insert’ ribbon. But when it comes to combining two chart types – for example a column chart with a line on top – many users suddenly struggle. But actually, it’s almost as simple as inserting a normal chart. Let’s have a look at how to do it and how to further adjust your chart.

Steps for combining two chart types

Creating a chart with two different chart types is comparatively simple in newer versions of Excel (the numbers are corresponding with the following picture):

Steps for combining two chart types in Excel
  1. Prepare you data. In this case, you have the data (column B, ‘Month’) for the x-axis in the first column. The second column (C, ‘Revenue’) contains the data for the columns of the chart. The last column (in this case the revenue per customer) has the data for the line graph which you want to show above the column chart.
  2. Click on Insert and click on Combo (on the charts section).
  3. Click on “Clustered Column – Line on Secondary Axis”.
  4. The result looks like no. 4.

If there is no ‘Combo’ chart type button…

Example: Create combo charts with Excel for Mac

Sometimes the combo chart type is not available, for example in Office for Mac. In such case you have to create the combination of the two chart types manually:

These steps work universally – also if you have a stacked or clustered column chart and want to display one series as another chart type.

Steps under Excel 2016

The chart menu has changed a little bit in Excel 2016. There are also new chart types available. The basic steps for creating combo charts are similar to before. Just follow the steps as shown above or this animation:

Steps for creating combo charts under Excel 2016

The gif above was too fast? Here are the steps in detail:

  1. Create a normal chart, for example stacked column.
  2. Right click on the data series you want to change.
  3. Click on “Change Series Chart Type”.
  4. Select your desired second chart type, e.g. line charts.
  5. If necessary set the tick at “Secondary Axis” if necessary.
  6. Confirm by clicking on OK.
Exit mobile version