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
Chart examples
This is an example of a 100% stacked area chart. This tricky chart type can be quite hard to read. The idea is to visually show a percentage distribution across categories at specific intervals, but you lose the ability...
This chart is an example of a 100% stacked column chart. The data shown in the chart represents projects over a three year period, categorized as hit goals, missed goals, and exceeded goals. I think this is a good...
Related chart types
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
