So, what can you see with this chart? Primarily, you can see that sales of Retrobags are collapsing while Organic Flannel makes up the slack. Hammocks and Banjo Packs are relatively stable. But what you can’t see is if overall sales are increasing (they are) or decreasing. Have you got a good example of a useful 100% stacked area chart? Leave a comment below if so, I’d like to add more good examples. The data used to plot this chart looks like this:

How to create this chart

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

100 Stacked Area Chart example Product mix over time - 24100 Stacked Area Chart example Product mix over time - 75100 Stacked Area Chart example Product mix over time - 71100 Stacked Area Chart example Product mix over time - 83100 Stacked Area Chart example Product mix over time - 38100 Stacked Area Chart example Product mix over time - 7100 Stacked Area Chart example Product mix over time - 13100 Stacked Area Chart example Product mix over time - 27