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.

DOWNLOAD WORKBOOK

Stacked Column

Helpful Resource:

project-management-bundle-excel-ad-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+