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 then you need to convert these to text by entering the apostrophe ‘ before the year.  If not, then it will simply include the Year value as part of the Totals.


Stacked Column

Helpful Resource:



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

100% Stacked Bar Chart 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.DOWNL...
100% Stacked Column Chart: Percentage Contribution... 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 thi...
Area Chart: Highlight Chart Sections When you are showing 12 month sales results using a Line Chart and want to highlight certain values within the chart to make them stand out (like Q2 & Q3 results), then an Area Chart will be needed.To do this there are a few steps to follow:1. Enter the Line Chart for...
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. ...