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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Clustered Column Chart: 12 Month Trend An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points.To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values.Below I sho...
Excel Cycle Charts Cycle Charts in Excel are easy to create using the Smart Art feature.There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle.Here is how you insert a Radial Cy...
Clustered Bar Chart: Year over Year Comparison If you want to compare products or businesses Year over Year and have category names which are way too long, then the Clustered Bar chart is the one for you.In the example below the category names relate to companies and I am comparing their sales for 2013 and 2014.DO...
Create a Box and Whisker Chart With Excel 2016 Box and Whisker Charts are one of the many new Charts available only in Excel 2016 and were originally invented by John Tukey in 1977.They show you the distribution of a data set, showing the median, quartiles, range and outliers.The X in the box represents the Mean. ...