• Home
  • Tools dropdown img
    • Spreadsheet Charts

      • ChartExpo for Google Sheets
      • ChartExpo for Microsoft Excel
    • Power BI Charts

      • Power BI Custom Visuals by ChartExpo
    • Word Cloud

  • Charts dropdown img
    • Chart Category

      • Bar Charts
      • Circle Graphs
      • Column Charts
      • Combo Charts
      • Comparison Charts
      • Line Graphs
      • PPC Charts
      • Sentiment Analysis Charts
      • Survey Charts
    • Chart Type

      • Box and Whisker Plot
      • Clustered Bar Chart
      • Clustered Column Chart
      • Comparison Bar Chart
      • Control Chart
      • CSAT Survey Bar Chart
      • CSAT Survey Chart
      • Dot Plot Chart
      • Double Bar Graph
      • Funnel Chart
      • Gauge Chart
      • Likert Scale Chart
      • Matrix Chart
      • Multi Axis Line Chart
      • Overlapping Bar Chart
      • Pareto Chart
      • Radar Chart
      • Radial Bar Chart
      • Sankey Diagram
      • Scatter Plot Chart
      • Slope Chart
      • Sunburst Chart
      • Tornado Chart
      • Waterfall Chart
      • Word Cloud
    • Google Sheets
      Microsoft Excel
  • Services
  • Pricing
  • Contact us
  • Blog
  • Support dropdown img
      • Gallery
      • Videos
      • Contact us
      • FAQs
      • Resources
    • Please feel free to contact us

      atsupport@chartexpo.com

Categories
All Data Visualizations Data Analytics Surveys
Add-ons/
  • Google Sheets
  • Microsoft Excel
  • Power BI
All Data Visualizations Data Analytics Surveys
Add-ons
  • Google Sheets
  • Microsoft Excel
  • Power BI

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

ChartExpo Survey



Home > Blog > Microsoft Excel

How to Make Overlay Graphs in Excel?

Excel offers a good selection of charts and graphs. But you may have a situation outside the norm.

how to overlay graphs in excel

For instance, you may need to visualize two sets of varying data for insights. Let’s say actual versus forecast revenue.

In this scenario, what’s the go-to chart for the graph?

You need Overlay Graphs in Excel for the task. These charts are also called Combination Graphs or Combo Charts.

Excel does not have ready-made and visually stunning Overlay Graphs for your analysis.

So, what’s the solution?

Download and install a particular third-party application (add-in) if your goal is to get ready-to-use and visually stunning Overlay Graphs.

Keep reading to discover more about this add-in.

In this blog, you’ll learn:

Table of Content:

  1. What is Overlapping Data in Excel?
  2. Video Tutorial: How to Display Overlapping Data in Excel?
  3. What is an Overlay Graph in Excel?
  4. Types of Overlapping Charts in Excel
    1. Dual Axis Line Chart
    2. Dual Axis Bar and Line Chart
    3. Multi-Axis Line Chart
    4. Overlapping Bar Chart
  5. How to Overlay Graph in Excel:(Step By Step)
  6. FAQs About Overlay Chart in Excel
  7. Wrap Up

Before jumping into the how-to guide, we’ll address the following question: what is a graph in Excel?

What is Overlapping Data in Excel?

Definition: Overlapping Data refers to the situation where data of 2 or more variables overlap each other. Sometimes we want to compare the data of 2 variables using a Bar Chart which overlaps bars of both variables instead of displaying them side by side.

An Overlapping Bar chart is best suited to comparing two distinct variables. An Overlapping Bar Chart in Excel is more valuable than a Stacked Bar Chart, especially if your goal is to display comparison insights.

How to Show Overlapping Data in Excel example

The visualization design is similar to a standard Stacked Bar Chart. However, unlike a Stacked Diagram, its composite variables that contribute to the whole, start at the baseline.

Besides, the chart requires three data columns or rows from your data set””one for categories, one for the series in each category, and one for values. Different types of data call for different types of charts.

While overlapping graphs are suitable for visualizing data overlaps, when it comes to showcasing both positive and negative aspects of data, a stacked waterfall chart is the ideal choice, and vice versa

The chart is more valuable than the Grouped Bar Chart because it uses color strategically to display comparison insights. More so, you can leverage the chart to display insights into current progress against the benchmark.

Video Tutorial: How to Display Overlapping Data in Excel?

In the following video, you will learn How to Display Overlapping Data in Excel.

What is an Overlay Graph in Excel?

Definition: A chart represents large sets of data using charts and diagrams.

To create a visualization, you start with a two-dimensional space, a vertical dimension (y), and a horizontal dimension (x).

Also, you need a data source.

Once a chart is ready, your task changes to translating data points in terms of patterns, relationships, and trends.

Charts and graphs can help you to forecast the performance of the metrics under study. For instance, you can predict performance with insights into past data if certain factors remain unchanged.

A graph in Excel is a diagram, a picture, a map, or a chart, including options like a Waterfall chart. You can use charts and graphs as backdrops for your data stories, especially during a board or investor meeting.

Microsoft Excel is one of the go-to tools for visualization among business owners.

And it’s available on Windows, macOS, Android, and iOS operating systems.

This spreadsheet application has calculation capabilities, pivot tables, charts, and Visual Basic for Applications.

In this blog, we’ll talk mainly about Excel.

So, what are the key types of Excel overlay charts?

Types of Overlapping Charts in Excel

Below are tested and proven Excel Overlay Charts and Graphs for your reference.

Let’s dive in.

  • Dual Axis Line Chart

how to overlay dual axis line chart in excel

A Dual Axis Line Chart is a visualization design you can use to display data with metrics with varying measures.

It uses two axes to easily showcase the relationships between two varying variables in terms of the scale of measurements.

The resulting curves comprise of series of data points called ‘markers’ connected by straight lines.

The visualization displays plenty of information using limited space. This means you can quickly uncover trends and patterns in your data with a glance.

If you want to make the most of limited space in your data visualization dashboard, your go-to chart should be a Multi-Axis Chart in Excel, such as the Dual Axis Line Chart. This type of chart is particularly useful for comparing complex data sets, like marginal revenue vs. marginal cost, in a single view.

How to make overlay graphs in Excel should never stress you. Keep reading to discover more.

  • Dual Axis Bar and Line Chart

how to overlay dual axis line and bar chart in excel

The Dual Axis Bar and Line Chart have a secondary axis to help you visualize data points with varying scales of measure.

For instance, the chart above has two Y-axis, which depicts sales and profit margins.

A secondary axis chart (such as the above) can help you display insights into more than one variable.

A Dual Axis Bar and Line Chart is an excellent example of an overlaid chart (a Bar Chart and Line Graphs).

Keep reading because, in the ensuing section, we’ll show you how to make an overlay graph in Excel.

  • Multi-Axis Line Chart

how to overlay multi axis line chart in excel

A Multi-Axis Line Chart uses 3 axes to illustrate the relationships between data points with different scales of measure.

For instance, the chart above has 3 Y-axes representing expenses, sales, and profits.

The Overlay visualization displays plenty of information using limited space. This means you can uncover trends and patterns quickly.

A Multi-Axis Chart in Excel is an overlay of Area and Line Graphs. And it can help you make comparisons between categories using a highly contrasting color scheme.

If you want to use limited space in your data visualization dashboard, use a Multi-Axis Line Chart.

  • Overlapping Bar Chart

how to overlay overlapping chart in excel

An OBC shares remarkable similarities with a standard Stacked Bar Diagram as well as a Clustered Stacked Bar Chart.

But its composite variables that contribute to the whole start at the baseline, unlike the latter visualization chart.

For instance, the chart above compares the actual versus forecast sales in various US cities.

We recommend you use the graph to compare two distinct metrics in your data. An OBC is handier than a Stacked Bar graph if you intend to display comparison insights.

In the coming section, we’ll show you How to Create an Overlay Chart in Excel.

You don’t want to miss this.

How to Overlay Graph in Excel:(Step By Step)

So, how do you overlay charts to create an all-in-one visualization with secondary Y-axes?

Excel is one of the popular tools of visualization among business owners. However, it lacks ready-made Overlay  Charts.

In other words, you’ll have to overlay charts manually to end up with insightful graphs, such as OBC & Multi-Axis Line Chart.

We’re not advising you to do away with Excel. 

There’s an amazingly affordable tool that comes as an add-in you can easily install in Excel to access ready-to-go and easy-to-customize Overlay Charts.

The application is called ChartExpo.

What is ChartExpo?

ChartExpo is an add-in you can easily install in your Excel to access ready-made and visually appealing Overlaid Charts.

How to make overlay graphs in Excel should never consume your time or overwhelm you.

Features and Benefits

  • You don’t need sophisticated coding skills to generate insightful charts for your stories.
  • ChartExpo is just $10 a month after the end of the trial
  • ChartExpo comes with a free 7-day trial. If unsatisfied with the tool within a week, you’re free to opt-out.

Example

This section will use an Overlay Chart to visualize the table below.

Let’s jump in.

Cities Forecast Sales
Los Angeles 2,627,049 2,476,774
Chicago 2,810,279 2,127,736
New York 2,441,855 2,611,717
Phoenix 2,397,170 2,663,863
Philadelphia 2,715,795 2,279,076
Miami 2,758,997 2,163,999

To get started with ChartExpo in Excel, follow the steps below:

  • Open your Excel desktop application.
  • Open the worksheet and click the Insert button to access the My Apps option.
insert chartexpo in excel
  • Click the Insert button to initiate the ChartExpo engine.
open chartexpo in excel
  • Once ChartExpo is loaded, you will see a list of charts.
list of charts in excel
  • Look for the Overlapping Bar Chart, and click on its icon to get started, as shown below.
search overlapping bar chart in excel
  • Highlight your data and click the Create Chart From Selection button, as shown.
create overlapping bar Chart in excel
  • Check out the final chart below.
how to overlay charts in excel

FAQs About Overlay Chart in Excel

How to do an overlay graph in Excel?

Follow the steps below to do an overlay graph in Excel.
  • Open your Excel desktop application.
  • Open the worksheet and click the Insert button to access the My Apps option.
  • Click the Insert button to initiate the ChartExpo engine.
  • Once ChartExpo is loaded, you will see a list of charts.
  • Look for the Dual Axis Bar and Line Chart, and click on its icon to get started, as shown below.
  • Highlight your data and click the Create Chart From Selection button, as shown.
  • Check out the final overlay chart in Excel.

The chart can help you compare categories using a highly contrasting color scheme.

Wrap Up

Excel offers a good selection of charts and graphs. But you may have a unique situation.

For instance, you may need to visualize two sets of varying data for insights. Let’s say actual revenue versus forecast revenue.

In this scenario, what’s the go-to chart for the graph?

You need Overlay Graphs for the task. These charts are also called Combination Graphs or simply Combo Graphs.

Excel does not have ready-made and visually stunning Overlay Graphs for your analysis.

How much did you enjoy this article?

ExcelAd2
Start Free Trial!
122158

Related articles

next previous
Microsoft Excel10 min read

Invoice Tracker Template in Excel for Better Insights

An invoice tracker Excel template helps track invoices, due dates, and payments. Learn how to use this template for better financial management.

Microsoft Excel12 min read

Key Performance Indicators in Healthcare for Better Insights

Key Performance Indicators in healthcare track patient care and efficiency. Learn about these KPIs, top examples, and how to use them to improve outcomes.

Microsoft Excel10 min read

BMI Calculation Formula in Excel for Better Fitness Insights

The BMI calculation formula in Excel helps track and analyze body mass index. Explore step-by-step instructions and tips to simplify BMI tracking in Excel.

Microsoft Excel29 min read

How to Create a Tornado Chart in Excel? A Complete Guide

Click to learn how to plot a Tornado Chart in Excel using easy-to-follow steps. Also, we’ll address the following question: what is a Tornado Diagram?

Microsoft Excel14 min read

How to Create a Scatter Plot in Excel with 3 Variables?

Click to discover how to create a Scatter Plot in Excel with 3 variables. We’ll also address the following question: why do we use Scatter Plot Graph?

ChartExpo logo

Turn Data into Visual
Stories

CHARTEXPO

  • Home
  • Gallery
  • Videos
  • Services
  • Pricing
  • Contact us
  • FAQs
  • Privacy policy
  • Terms of Service
  • Sitemap

TOOLS

  • ChartExpo for Google Sheets
  • ChartExpo for Microsoft Excel
  • Power BI Custom Visuals by ChartExpo
  • Word Cloud

CATEGORIES

  • Bar Charts
  • Circle Graphs
  • Column Charts
  • Combo Charts
  • Comparison Charts
  • Line Graphs
  • PPC Charts
  • Sentiment Analysis Charts
  • Survey Charts

TOP CHARTS

  • Sankey Diagram
  • Likert Scale Chart
  • Comparison Bar Chart
  • Pareto Chart
  • Funnel Chart
  • Gauge Chart
  • Radar Chart
  • Radial Bar Chart
  • Sunburst Chart
  • see more
  • Scatter Plot Chart
  • CSAT Survey Bar Chart
  • CSAT Survey Chart
  • Dot Plot Chart
  • Double Bar Graph
  • Matrix Chart
  • Multi Axis Line Chart
  • Overlapping Bar Chart
  • Control Chart
  • Slope Chart
  • Clustered Bar Chart
  • Clustered Column Chart
  • Box and Whisker Plot
  • Tornado Chart
  • Waterfall Chart
  • Word Cloud
  • see less

RESOURCES

  • Blog
  • Resources
  • YouTube
SIGN UP FOR UPDATES

We wouldn't dream of spamming you or selling your info.

© 2025 ChartExpo, all rights reserved.