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+

Related Posts

Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt. To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function. The RPT function uses the vertical bar character | as the first argument: text and references the va...
Apply Custom Chart Styles Excel's default Charts are bland and ugly but you can certainly spice them up to your liking. Using the Shape Styles group in the ribbon menu you can customize your Excel chart the way you or your boss wants. There are several formatting options including Shape Styles, Shap...
Add an Interactive Vertical Column in Your Excel L... With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and make it interactive with a Scroll Bar! The reason why I do this, is to use the vertical column to highlight a specific point in my Excel chart whilst I am presenting the data to my stakeholde...