Excel Stacked Column chart

The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total.

For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then this is the chart for you.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Select the table on where we want to create the chart on.  

Excel Stacked Column chart

 

STEP 2: Go to Insert > Column > 100% Stacked Column 

Excel Stacked Column chart

 

Your chart is now ready:

Excel Stacked Column chart

 

Excel Stacked Column chart

Helpful Resource:

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

Thermometer Excel Chart Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own. A Thermometer Chart gives you a good view of the percentage of progress made on your project, budget etc. We are going ...
Overlap Graphs in Excel 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 pres...
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 ...
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...