How to Create a Combo Chart in Excel (2 Easy Ways)

While working in Excel, we often need to create a combo chart. A combo chart not only helps us to visualize our data but also allows us to compare various aspects of our data. As a result, we can make decisions based on the information from the combo chart. In this article, we will discuss 2 simple ways to create a combo chart in Excel.


Download Practice Workbook


What Is a Combo Chart?

As the name indicates, a combo chart is nothing but a combination of two or more different types of charts. Such as Column Chart, Line Chart, Bar Chart, etc. In the following image, a combo chart is illustrated. In this combo chart, we used a combination of a Clustered Column Chart and a line chart.

example of a combo chart in Excel


2 Simple Methods to Create a Combo Chart in Excel

In this section of the article, we will learn 2 easy ways to create a combo chart in Excel. Here, in the following dataset, we have sales data with Target and Achieved sales figures for a store. Our goal is to create a combo chart with this data.

how to create a combo chart in excel

Not to mention that we have used the Microsoft Excel 365 version for this article; you can use any other version according to your convenience.


1. Creating a Combo Chart with Single Axis

Firstly, we will explore creating a combo chart with a single axis. Let’s say, you want to create a combo chart of Target and Achieved sales based on a single axis. That means, two types of data will be represented regardless of their specific maximum and minimum values. Please follow the steps mentioned below.

Step 01: Inserting Chart

  • Firstly, go to the Insert tab from Ribbon.
  • Following that, select the Recommended Charts option.

Creating a Combo Chart with Single Axis

As a result, the Insert Chart dialogue box will open as shown in the following image.

Note: You can also use the keyboard shortcut ALT + N +R to directly open the Insert Chart dialogue box from your worksheet. 

  • Now, in the Insert Chart dialogue box, go to the All Charts tab.
  • After that, choose the Combo option.

Step 02: Selecting Chart Types for Series

  • Firstly, for the Target series choose the Clustered Column Chart Type.
  • Then, for the Achieved series select the Line Chart Type.
  • Next, click on OK.

Selecting Chart Types for Series to create a combo chart in excel

Consequently, the following combo chart will be available on your screen.

Step 03: Formatting Combo Chart

  • Firstly, type in the title you want to add in the marked box of the following image. In this case, we used the chart title as Single Axis Combo Chart.

Formatting Combo Chart to create a combo chart in excel

  • Now, to change the Style of the combo chart, click on the paintbrush icon as marked in the image below.
  • After that, select your preferred Style.

Subsequently, you will see that your combo chart is formatted with your preferred style as shown in the following picture.

  • After that, click on the plus (+) icon as marked in the following image.
  • Then, check the box of Axis Titles.

  • Following that, edit the Axis Titles and you will get your combo chart as shown in the following image.

final output of method 1 to create a combo chart in excel


2. Constructing a Combo Chart with Double Axes

We can also construct a combo chart with double axes. For example, let’s say you want to create a combo chart showing Target sales, and Achieved sales on 2 axes. That indicates you need to add a secondary axis to your combo chart. Let’s use the steps discussed below to do this.

Steps:

  • Firstly, follow the steps mentioned in Step 01 of the 1st method to open the Insert Chart dialogue box.
  • Following that, from the Insert Chart dialogue box, choose Clustered Column Chart Type for the Target series.
  • Then, choose Line Chart Type for Achieved series.
  • Now, check the box of Secondary Axis beside Chart Type of Achieved series.
  • Next, click on OK.

Constructing a Combo Chart with 2 Axes in Excel

Consequently, you will have the following combo chart on your worksheet.

As a result, you will see the following output as shown in the following image.

final output of method 2 to create a combo chart in excel


How to Create a Combo Chart from an Existing Chart

Microsoft Excel is user-friendly and versatile software. Excel allows us to customize our work at any stage of it. We can create a combo chart from an existing chart. In the following image, we have a Column Chart. We will create a combo chart from this Existing Column Chart. Let’s follow the steps mentioned below to do this.

How to Create a Combo Chart from an Existing Chart in Excel

Steps:

  • Firstly, right-click on anywhere on the chart area.
  • Following that, choose the Change Series Chart Type option.

As a result, the Change Chart Type dialogue box will be visible on your worksheet as shown in the following image.

  • Now, in the Change Chart Type dialogue box, select Clustered Column Chart Type for the Target series.
  • After that, choose Line Chart Type for Achieved series.
  • Subsequently, check the box of Secondary Axis beside Chart Type of Achieved series.
  • Lastly, click on OK.

As a result, you will have the following output on your worksheet.

Consequently, you will see the combo chart shown below on your worksheet.


Create Combo Chart with Multiple Series

Combo charts are a fascinating feature of Excel. It allows us to incorporate multiple series in the combo chart at a time. In this section of the article, we will discuss the detailed steps to create a combo chart with multiple series.

In the following dataset, we have monthly sales data of a store along with various sales figures. Let’s say, you want to compare the Target sales amount with the Achieved sales amount while showing the Difference between them as well as the Incentive amounts in the same combo chart. Let’s follow the steps mentioned below to do this.

Create a Combo Chart with Multiple Series in Excel

Steps:

  • Firstly, use the steps used in Step 01 of the 1st method to open the Insert Chart dialogue box.
  • Now, in the Insert Chart dialogue box, choose the following options.
    • For Target series → Clustered Column 
    • For Achieved series → Line 
    • Check the box of Secondary Axis beside the Chart Type of Achieved series.
    • For Difference series → Line
    • For the Incentive series → Clustered Column
  • Finally, click on OK.

As a result, you will have the following combo chart on your worksheet.

Subsequently, you will have your combo chart with multiple series as demonstrated in the following picture.


Conclusion

That’s all about today’s session. I strongly believe that this article was able to guide you to create a combo chart in Excel. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!

Tags:

Kawser

Kawser

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 them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo