How to Create a Combo Excel Chart

I want to teach you how to make a combo chart in Excel in this tutorial.

Your data might have different kinds of information. To show that information perfectly in a single chart, you might combine two or more charts. In this article, I will show you how you can make a combo chart in Excel spreadsheet.

So, let’s start.

To do this, I have used the following data table.

Elements of an Excel Chart

I shall use this sample data to make a combo chart.

The chart I am going to make is like the following:

Elements of an Excel Chart

I am going to explain how to create this type of chart.

How to Create a Combo Chart

Combo chart is not a unique type of chart. You can just make a combo chart combining two another unique charts. Like you can make a combo chart combining a line chart and a clustered column chart. Our above chart is a combination of a line chart and a clustered column chart. Please download the working file I have used to create this tutorial before you read this post.

Follow these steps to create a combo chart

  • Click any cell within the data zone.
  • Choose Insert ➪ Charts ➪ Recommended Charts. Insert Chart dialog box appears.
Elements of an Excel Chart

Insert ➪ Charts ➪ Recommended Charts

  • Activate All Charts tab of Insert Chart dialog box.
  • Select Combo from the left side options.
  • I have chosen Clustered Column chart type for Sales Calls data series.
  • And chosen Line with Markers chart type for Units Sold data series.
  • I want to make Units Sold as the secondary axis.
  • Then click OK. Insert Chart dialog box disappears.
Elements of an Excel Chart

Insert Chart dialog box.

  • We shall get a chart like this.
Elements of an Excel Chart

This raw chart I am getting now. Let’s polish it some other tools.

Read More: Excel Charts with Dynamic Title and Legend Labels

Adding Data Label to this chart

I want to add a data label to this chart. To do this:

  • Activate the chart
  • Click on the CHART ELEMENTS icon (“+” sign icon) from the top-right corner of the chart. A shortcut menu appears.
  • Hover the mouse over Data Label option from the list. Don’t click it. A little right-arrow icon appears, click on this icon.
  • Another shortcut menu appears. Choose More Options… option from this list.
Elements of an Excel Chart

Adding Data Label to a chart.

  • Format Data Labels task pane appears. Deselect Value from the LABEL OPTIONS
Elements of an Excel Chart

Deselect Value option from the LABEL OPTIONS.

The chart so far looks like the following figure:

Elements of an Excel Chart

So the chart looks like this one.

Adding Axis Titles to the Chart

Now I want to add the Axis Titles to the Chart. There are three axes in this chart. The x-axis is for Month, First Y-axis is for Sales Calls and Secondary Y-axis is for Units Sold. I shall mark them on the chart. Use these steps:

  • Activate the chart again.
  • Click on the CHART ELEMENTS icon (“+” sign icon) from the top-right corner of the chart. A shortcut menu appears.
  • Select Axis Titles option from the shortcut menu. Three Axis Title fields will appear in the relevant axes.
Elements of an Excel Chart

Axis Title Change of the chart.

  • Double Click on every Axis title to get the Edit mode (in Edit mode, you can change the name of the Axis), change the name of the Axis Title and then change the format of Axis title like the following figure.
Elements of an Excel Chart

Finally, I get the chart like this one.

Wrapping Up

So, this was all from me on this topic. Let me know in case you face any issues while using this article. Thank you for reading.

Happy Excelling ☕

Download Working File

Download the working file from the link below:

Combo-Chart.xlsx

Related Articles


Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply