A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total.

So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year.

DOWNLOAD WORKBOOK

100pc Stacked Bar

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

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...
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...
Save A Chart Template Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template.So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it s...
Excel Chart Template Infographic Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data.The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey. ...