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

Copying & Moving Excel Charts I am going to show your three quick ways to copy and move your Excel charts:#1 - COPYING A CHARTClick on the chart with your left mouse key and at the same time hold down the CTRL key to copy it and move the chart to wherever you want.When you are done, let go of the ...
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...
Line Chart: Trend with lots of data A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend.An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I ...
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. ...