Overlapping graphs in Excel is used to compare two sets of data in one graph, like Actual v Plan results.

This overlay of graphs may seem like a difficult exercise but it is a very easy process.

First you need to edit your “Plan” graph by clicking on its series and pressing CTRL+1 shortcut.  Then within the Format box you need to choose:

FILL: NO FILL
BORDER COLOR: SOLID LINE & DARK
BORDER STYLE: 2pt WIDTH

Then you need to edit your “Actual” graph by clicking on its series and pressing CTRL+1 shortcut.  Then within the Format box you need to choose:

FILL: SOLID FILL & LIGHT COLOR
SERIES OPTIONS: 100% OVERLAPPED
GAP WIDTH: 60%

See how this is achieved below…

DOWNLOAD WORKBOOK

Overlap Graphs2

HELPFUL RESOURCE:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

XY Scatter Chart: Related Variables When you want to find out whether or not 2 variables are related or correlated, then an XY Scatter Chart should be used to plot the graph. Related variables will show up on the graph as dots that are almost in a straight line.  Examples of variables that have relationships cou...
Win/Loss Sparklines When you have  a large data set with positive and negative numbers, a great way to visualize the trend is to add a Win/Loss Sparkline next to your data. That way you or the reader can easily spot the trends and patterns. To enter a Win/Loss Sparkline in Excel you firstly ne...
Create a Treemap Chart With Excel 2016   Treemap Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month. The tree branches are represented by rectangles, wherein each rectangle's siz...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...