Exceljet

Quick, clean, and to the point

100% Stacked Area Chart

100% stacked area chart example

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