Excel offers a good selection of charts and graphs. But you may have a situation outside the norm.
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 (Overlapping Charts).
Keep reading to discover more about this add-in.
In this blog, you’ll learn:
Before jumping into the how-to guide, we’ll address the following question: what is a graph in Excel?
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. 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?
Below are tested and proven Excel Overlay Charts and Graphs for your reference.
Let’s dive in.
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. And this means you can quickly uncover trends and patterns in your data with a glance.
If you want to use limited space in your data visualization dashboard, your go-to chart should be a Dual Axis Line Chart.
How to make overlay graphs in Excel should never stress you. Keep reading to discover more.
A Dual Axis Bar and Line Chart has 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 margin.
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 overlay graph 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 overlapping visualization displays plenty of information using limited space. And 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.
An Overlapping Bar chart shares remarkable similarities with a standard 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 Overlapping Bar Chart is handier than a Stacked Bar graph if you intend to display comparison insights.
In the coming section, we’ll show you the best chart to show overlapping data.
You don’t want to miss this.
There’s no single best chart for showing overlapping data. You can use:
In this blog, we’ll use an Overlapping Chart (one of the overlaid graphs) to visualize sample data.
Finally, we’re at the blog’s core: How to make overlay graphs in Excel to create charts, such as Multi Axis Line Charts.
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 Overlapping Bar Charts.
In other words, you’ll have to overlay charts manually to end up with insightful graphs, such as Overlapping Bar Charts.
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 Overlapping Bar 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.
This section will use an Overlapping Bar 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:
An Overlapping Bar chart shares remarkable similarities with a standard Stacked Bar Chart.
But its composite variables that contribute to the whole, start at the baseline, unlike the latter visualization chart.
We recommend you use the graph to compare two data points with varying measures.
A Multi Axis Line Chart uses 3 axes to illustrate the relationships between data points with different scales of measure.
The overlapping visualization displays plenty of information using limited space. And this means you can uncover trends and patterns quickly.
The chart can help you compare categories using a highly contrasting color scheme.
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?
Learn how to get the most out of an exit survey questions with ChartExpo. We will teach you how to take that data and display it in an appealing visual.
This guide introduces you to the top 10 data visualization techniques. Click to learn how to create insightful charts and graphs in Excel with examples.
What is Data Analytics? What is Business Analytics? Click to learn about the differences and types of Business Analytics vs. Data Analytics.
