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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

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 ...
Stacked Column Chart: Compare Contributions The Stacked Column chart is used in Excel to compare the contribution of a value to a Total. For example, if you want to show the North & South sales for the last 5 years then this is the chart for you as I explain below. NB: If you are using Years as your first column ...
Add High & Low Points in an Excel Sparkline Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Sparkline pinpoints your strong and weak data points. To enter a High or Low marker you need to click inside your Sparkline which will activate the Sparkline Tools...
Custom Chart Labels Using Excel 2013 In a previous blog post we created a Benchmark Chart using Excel 2013.  We are going to extend this concept and add some cool looking custom chart labels to make our chart more informative. View the Benchmark Chart using Excel 2013   DOWNLOAD EXCEL WORKBOOK STEP ...