100% Stacked Area Chart

A 100% Stacked Area Chart is a built-in Excel chart type, with data plotted as areas and stacked so that the cumulative area always represents 100%. Stacked Area charts can show a progression and composition over time, and the 100% Stacked Area Chart is meant to show the percentage that each component contributes when the cumulative total is not important.
Pros
- Can show trends over periods of time
- Can show component contribution changes over time
Cons
- Non-intuitive presentation may be unfamiliar to many
- Hard to read as data series are added
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.