Pinterest Pixel

Stacked Column Chart: Compare Contributions

The Stacked Column chart is used in Excel to compare the contribution of a value to a... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Stacked Column Chart: Compare Contributions | MyExcelOnline Stacked Column Chart: Compare Contributions | MyExcelOnline

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 Chart: Compare Contributions | MyExcelOnline
download workbookStacked-Column.xlsx

 

Helpful Resource:

Clustered Bar Chart: Year to Date Sales

 

If you like this Excel tip, please share it
Stacked Column Chart: Compare Contributions | MyExcelOnline Stacked Column Chart: Compare Contributions | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...