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

Create a Histogram Chart With Excel 2016 Histogram Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common. In this example I show you how easy it is to insert a His...
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...
Replace Excel Formatting with Another Formatting Imagine this, you have a table full of bold text.  The bold text could also be all over your worksheet in random cells. Then you decide that the bold text does not suit your expected design and prefer red colored text instead. What would you do? Changing all of the forma...
Benchmark Chart in Excel 2010 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. I will show you how to do this using Using Excel 2010. DOWNLOAD EXCEL WORKBOOK STEP 1: Enter your data into three ...