Categories
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:
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.
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:
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.
Check out the key components of the Combo chart in Excel (below).
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.
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:
You can use the Combo Charts to measure metrics, such as the billable hours vs. revenue collected.
If you belong to the manufacturing industry, use these charts to compare units sold versus sales revenue across a given period.
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.
| Months | Sales | Profit Margin |
| Jan | 965 | 16 |
| Feb | 385 | 31 |
| Mar | 1118 | 15 |
| Apr | 639 | 12 |
| May | 359 | 22 |
| Jun | 1622 | 14 |
| Jul | 1750 | 24 |
| Aug | 1001 | 12 |
| Sep | 1841 | 29 |
| Oct | 1632 | 12 |
| Nov | 1547 | 39 |
| Dec | 531 | 19 |
To get started with Excel, follow the steps below:
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.
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:
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.
To get started with ChartExpo for Excel add-In, follow the simple and easy steps below.
Once you are logged in you will see ChartExpo interface in your sheet.
Even you will type double in the search box, charts related to the word will be short listed.
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.
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?
| Months | Sales | Profit Margin |
| Jan | 965 | 16 |
| Feb | 385 | 31 |
| Mar | 1118 | 15 |
| Apr | 639 | 12 |
| May | 359 | 22 |
| Jun | 1622 | 14 |
| Jul | 1750 | 24 |
| Aug | 1001 | 12 |
| Sep | 1841 | 29 |
| Oct | 1632 | 12 |
| Nov | 1547 | 39 |
| Dec | 531 | 19 |
To get started with the Combo Chart maker (ChartExpo), follow the simple steps 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:
Recap: A Combo Chart is a hybrid of two or more chart types, such as the Double Axis Line and Bar 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.
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.
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.
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.
How much did you enjoy this article?
We will help your ad reach the right person, at the right time
Actionable insights discovered for you. Now you can do more in less time.
PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.
Frequent audits will help you optimize your PPC campaign for success.
Visualizations give you the ability to instantly grasp the insights hidden in your numbers.
Experience the new revolution in reporting … click your way to insights, don’t scroll.
Calculate the number of combinations in your PPC campaign. It may surprise you.
Related articles
Click to learn the top 6 business charts and graphs. Also, we’ll address the following question: what is a chart?
Focusing on customer satisfaction can make or break your business’ growth. Learn how to measure customer satisfaction to have happier customers.
Click to learn the best SEO report example you can use to track success. Also, we’ll address the following question: what is an SEO report?
