• Home
  • Tools
    • PPC Signal
    • PPCexpo Keyword Planner
    • PPC Audit
    • ChartExpoTM PPC Charts
    • PPCexpo PPC Reports
    • Combinations Calculator
  • Pricing
  • Contact us
  • Resources
    • PPC Signal Dashboard
    • PPC Reports Templates
    • PPC Guide
    • Join Our Facebook Group
    • Charts
      • CSAT Score Survey Chart
      • Likert Scale Chart
      • Pareto Chart
      • Sankey Diagram
  • Blog
Categories
All Digital Marketing PPC SEO SMM Data Visualization
All Digital Marketing PPC SEO SMM Data Visualization

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok
Home > Blog > Digital Marketing > Data Visualization >

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.

combo chart in Excel
combo chart in Excelcombo chart in Excel

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.

MonthsSalesProfit Margin
Jan96516
Feb38531
Mar111815
Apr63912
May35922
Jun162214
Jul175024
Aug100112
Sep184129
Oct163212
Nov154739
Dec53119

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.
combo chart in Excel

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.

combo chart in Excelcombo 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.
combo chart in Excel
  • Search for a ChartExpo add-in in the My Apps Store.
combo chart in Excel
  • Click the Insert button, as shown above.
combo chart in Excel
  • Click the Sign In with Microsoft button link, as shown above.
combo chart in Excel
  • 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.

combo chart in Excel
  • 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.

combo chart in Excel
  • 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.
combo chart in Excel

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?

MonthsSalesProfit Margin
Jan96516
Feb38531
Mar111815
Apr63912
May35922
Jun162214
Jul175024
Aug100112
Sep184129
Oct163212
Nov154739
Dec53119

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.
combo chart in Excel
  • Once the Double Axis Line and Bar Chart show, click the Create Chart from Selection button, as shown below.
combo chart in Excel
  • You will have default look of your chart based on this data as below:
combo chart in Excel

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.

combo chart in Excel

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

combo chart in Excel
combo chart in Excelcombo chart in Excel

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.

combo chart in Excel

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:

combo chart in Excel
combo chart in Excelcombo chart in Excel

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.

How much did you enjoy this article?

We will help your ad reach the right person, at the right time

PPC Signal

Your Data. Your Insights.

Actionable insights discovered for you. Now you can do more in less time.

PPCexpo Keyword Planner

Find the Perfect Keyword. Surprise Yourself.

PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.

PPC Audit

Free Google Ads Audit Report.

Frequent audits will help you optimize your PPC campaign for success.

ChartExpo PPC Charts

Picture a Thousand Numbers. See the Big Picture.

Visualizations give you the ability to instantly grasp the insights hidden in your numbers.

PPCexpo PPC Reports

Simple and Easy PPC Reporting. For Everyone.

Experience the new revolution in reporting … click your way to insights, don’t scroll.

Combinations Calculator

Do the Math.

Calculate the number of combinations in your PPC campaign. It may surprise you.

Insightful pay-per-click tips and tricks, delivered to your inbox weekly.

CTR Survey

ppc signal ad
chartexpo ad
ppc audit ad
keyword planner ad
120280

Related articles

next previous
Data Visualization11 min read

How to Craft Engaging & Compelling Google Docs Questionnaires?

Click to learn how to craft engaging Google Docs questionnaires. Also, we’ll show you tips for effective questionnaire design.

Data Visualization11 min read

How Do Google Forms Work: A Step-by-Step Guide

Click to learn the following: how does Google Forms work? Also, we’ll show you tips for using Google Forms effectively.

Data Visualization8 min read

How to Build an Effective Customer Feedback Loop?

Click to learn how to build an effective customer feedback loop. Also, we’ll show you how to analyze customer feedback loop data.

Data Visualization9 min read

How are Surveys Conducted? Easy Steps to Follow

Click to learn the answer: “How are surveys conducted?” Also, you’ll learn how to analyze survey results.

Data Visualization8 min read

How to Improve Customer Service Skills?

Click to learn how to improve customer service skills. Also, you’ll learn how to create a customer service survey.

PPCexpo

  • Home
  • Tools
  • Pricing
  • Contact us
  • PPC Guide
  • Blog
  • Sitemap
  • © 2023 PPCexpo, all rights reserved.

Company

  • Contact us
  • Privacy policy
  • Security
  • Patent

Tools

  • PPC Signal
  • PPCexpo Keyword Planner
  • PPC Audit
  • ChartExpo™ PPC Charts
  • PPCexpo PPC Reports
  • Combinations Calculator

Quick Links

  • PPC Guide
  • PPC Signal Dashboard
  • PPC Reports Templates
  • ChartExpo™ for Google Sheets
  • ChartExpo™ for Microsoft Excel
  • PPCexpo Keyword Planner Google Chrome Extension

Charts

  • CSAT Score Survey Chart
  • Likert Scale Chart
  • Pareto Chart
  • Sankey Diagram

Category

  • PPC
  • SEM
  • SEO
  • SMM
  • Data Visualization
  • Others
Join our group

Benefits

  • Q&A on PPC advertising
  • Get expert advice
  • Great PPC discussions
  • Stay updated with PPC news
  • Quick support on tools
  • Discounts and special offers