How to Create a Combo Chart in Excel in 2023?

Imagine how lean your visualization dashboard would be if you could use a single chart to perform the job of two?

Well, we’re not talking about some utopia world. The world we’re talking about exists as you read this.

There’s a visualization design that can help you display insights into two different metrics in your data. Yes, you read that right. Essentially, it can perform the work of two charts.

The chart we’re talking about is called a Combo Chart in Excel.

The Combo chart in Excel can help you save a lot of space and time when visualizing two different data series.

You can supercharge your tool by installing third-party add-in to access Combo chart in Excel templates.

In this blog, you’ll learn the following:

• What is a Combo Chart in Excel?
• How to create Combo chart in Excel
• How to Install ChartExpo in Excel

How to Create a Combo Chart in Excel in Data Storytelling

Before we dive right into the how-to guide, let’s define the chart we’ll be talking about throughout the blog post.

So here we go.

What is a Combo Chart in Excel?

A Combo Chart combines Column and Line Charts.

You can make a Combo Chart with data that share a common string, such as a financial year. This chart can help you answer questions about your data, such as:

What are the trends for the same categories in data?

The Combo visualization design provides you with a flexible way of displaying data. Besides, it forms the basis of data visualization designs, such as the Pareto or 80/20 visualization.

There’s a wider variety of Combination Charts in Excel you can use for your data stories, namely:

• Double Axis Line and Bar Chart
• Area Line Chart
• Dual Axis Grouped Bar Chart
• Vertical Axis Line Chart

In this blog post, we’ll primarily talk about the Double Axis Line and Bar Chart (a Combo chart in Excel variant).

Use Combo chart in Excel if your objective is to validate the relationship between two variables with different magnitudes and scales but related in context.

For example, you can use a Combination Chart in Excel to display insights into different sales metrics that share a common denominator, i.e., the financial year.

You can also use this chart to display insights into hidden patterns, trends, and outliers in your raw data.

The General Structure of a Combination Chart in Excel

Check out the key components of the Combo chart in Excel (below).

• Variables on the primary (left) side of a Combo Chart define the scale for that y-axis.
• Similarly, data points on the secondary (right) side of the chart define the scale for the y-axis.
• You can use lines and bars in a single chart to display insights into the relationship between varying variables.
• This chart can only display one hierarchy at a time.

For example, if the first cell selected is a quarterly value, other periods, such as monthly and annual values, will be excluded – only quarterly values will be displayed.

• If using a Line and Bar Combo visualization, then the lines should be in the foreground. And the bars should be in the background.

So When Should You Use the Combo chart in Excel?

Use the Combination Chart in Excel if your goal is to have a lean visualization dashboard that displays tons of insights.

Combo Charts, such as the Double Axis Line and Bar Graphs, can help you display insights into the relationship between two different data points.

For instance, these visualization diagrams can help you show insights into the relationship between forecasted and actual sales across a specified period.

Besides, you can use Combo Charts to extract comparison insights into key categories using high contrasting color schemes.

The Combo chart is a must-have tool for the sales department because it can convey insights into target versus actual sales revenue in a given financial year.

Furthermore, sales managers can leverage this chart to uncover the best and worst-performing staff.

How?

This visualization chart can display insights into the revenue, and the number of deals closed by sales associates in a compact manner.

Check out other successful applications of Combination Charts in Excel below:

• Finance

You can use the Combo Charts to measure metrics, such as the billable hours vs. revenue collected.

• Manufacture

If you belong to the manufacturing industry, use these charts to compare units sold versus sales revenue across a given period.

How to create Combo chart in Excel

This section will take you through how you can use Excel to visualize data using Combo Charts.

Let’s use the data below for our example.

To get started with Excel, follow the steps below:

• Select the range of cells you want to visualize–A1:C13 in this example.
• Next, click Insert > Insert Combo Chart.
• Select Clustered Column — Line.

We acknowledge that Excel is among the most-used data visualization tools by most professionals and businesses. More so, it has been there for decades, plus it’s familiar to many.

However, this does not mean you should settle for less.

In other words, if your goal is to create insightful and easy-to-interpret Combo Charts, you’ve got to think beyond Excel.

Keep reading to discover more.

How can You Visualize Your Data with Ready-made Combination Charts in Your Excel?

To access an insightful and visually appealing Combination Chart in Excel, you have to install third-party apps (add-ins). There are thousands of add-ins you can find in Excel’s app store.

To save you time, we’ve tested hundreds of add-ins to find the best one for your day-to-day visualization needs.

ChartExpo ticks all the boxes with respect to the following:

• Ease of use
• Ease of access
• Number and quality of charts available
• Affordability

If your goal is to extract insights into two different variables in your data, your go-to chart maker should be ChartExpo.

In the coming section, you’ll learn how you can install ChartExpo add-in to access advanced Combo chart in Excel.

How to Install ChartExpo in Excel

To get started with ChartExpo for Excel add-In, follow the simple and easy steps below.

• Open the worksheet and click the Insert menu button.
• Click the My Apps button and then click the See All, as shown.

• Search for a ChartExpo add-in in the My Apps Store.

• Click the Insert button, as shown above.

• Click the Sign In with Microsoft button link, as shown above.

• Log in with your Microsoft account or create a new account.
• Enter your account and provide ChartExpo with permission to operate in your Excel spreadsheet.

Once you are logged in you will see ChartExpo interface in your sheet.

• Click the Search box and type the chart you want to visualize your data e.g Double Axis Line and Bar Chart provided by ChartExpo is fulfilled the requirement of Combo Chart in Excel.

Even  you will type double in the search box, charts related to the word will be short listed.

• Alternatively, click the Category button on your top right-side to view all the six major categories in ChartExpo, this chart is available in Pay-per-Click (PPC) Charts category.

In the coming section, you’ll get to see the Double Axis Line and Bar Chart (a Combo chart in Excel type) in action.

Let’s jump right in.

Combo Chart Example using ChartExpo

Let’s visualize the tabular data below using the Double axis Line and Bar Chart (one of the combination charts in Excel).

Are you ready?

To get started with the Combo Chart maker (ChartExpo), follow the simple steps below:

• Export the data above into your Excel sheet and select your desire visualization i.e. Double Axis Line and Bar Chart.

• Once the Double Axis Line and Bar Chart show, click the Create Chart from Selection button, as shown below.

• You will have default look of your chart based on this data as below:

This visualization is based on percentage values of the two columns in the sheet Sales and Profit margin. We can change the setting of the chart to see the visualization on actual data not on percentage.

You can click on Settings on top of the interface then in the property section open Chart Drawing and the select “Value Based” and then click on Apply.

You will have following look of your visualization based on values.

You can click on Edit Chart as shown above.  After that you can click on pencil icon on left Axis and then find property Label Text and then add Prefix “$” sign, after that click on Apply All it will apply dollar sign with the axis.

Same you can do with right axis to add % as postfix, moreover you can add axis labels and change other properties to see your chart by exploring more properties final look you can give your data as belows:

Insights

• Blue bars and trend lines are showing sales whereas profit margin is shown with brown color.
• P1 point in the end of x-axis showing is actually the predictive point on chart ending with the trend of sales and profit margin.
• Sales and profit margin trends going upward.
• Only 4 months (Feb, May, Nov, and Dec) have reached to highest points.
• Profit margin remain lowest in May. Where as June, July, September and November remained good months in getting good profit margin.

Advantages of Combination Chart in Excel

Recap: A Combo Chart is a hybrid of two or more chart types, such as the Double Axis Line and Bar Chart.

• You can easily display your insights into two different metrics without using an extra chart.
• Combo Charts allow you to plot values with varying scales and magnitudes.

FAQs:

What is a combo chart?

A Combo Chart is a combination of Columns and Line Graphs.

You can make a combo chart with a single dataset or with two datasets that share a common string field, such as a financial year. You can use this chart to answer questions about your data.

How to create a Combo Chart in Excel?

Excel spreadsheet’s library has pretty basic Combination Charts that need more time to edit. Essentially, customizing and editing your charts can consume a lot of time.

But, you can supercharge your Excel with third-party add-in, such as ChartExpo to access advanced Combo Graphs, such as the Double Axis Line and Bar Charts.

What is the Combo Chart good for?

You can use Combination charts in Excel to display insights into varying metrics within a single view. You can also use them to visually highlight the differences of categories in data.

If your goal is to save space and create a lean data visualization dashboard, then your go-to tool should be this chart.

Wrap Up

Displaying insights into the trend and relationship of two different metrics in your data should never be nerve-wracking or time-consuming.

Use Combo chart in Excel for a change.

This (above) visualization design can help you save a ton of space in your dashboard.

We recommend you to think beyond your Excel, to access Combo Charts that are simple to interpret.

Why?

Combination Charts in Excel are very basic and require a lot of effort and time to edit. But, we’re not recommending you to do away with Excel.

Install third-party apps, such as ChartExpo into your Excel to access advanced Combo Charts.

ChartExpo is an add-in you can easily download and install in your Excel app. Besides, this tool comes loaded with insightful and easy-to-interpret Combination Charts, plus over 50 more advanced charts.

With this intuitive tool, you don’t need programming or coding skills to visualize your data.

Sign up for a 7-day free trial today to access an easy-to-interpret and visually appealing Combination Chart in Excel.