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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Benchmark Chart in Excel 2013 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months.There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...
Excel Cycle Charts Cycle Charts in Excel are easy to create using the Smart Art feature.There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle.Here is how you insert a Radial Cy...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization:Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story.You can adjust the WIDTH of the line to make it as thin or thick as you like.You can make your line chart have a COMPOUND or DASH effect.You can also add...