100% Stacked Area Graph to Measure Portions Over Time

I just started using this chart because I needed to measure how performance in my data changed against each month. This is much better than doing a standard area chart because you can actually compare each colour directly as it’s all in percentages. Check out the differences below.


STANDARD STACKED AREA CHART

As you can see from this chart, it’s difficult to make a direct comparison especially during the beginning of the chart. What I’m interested in is being able to compare each results directly at any given time as well be able to describe the data as being “twice as large as another entry”.


100% STACKED AREA CHART

Here is a view of the same data except instead of the value in the data set we use the value of it as a percentage of the total for that row. As you can see, 2017-7 is significantly larger than the rest and there appears to be a dip in the data around day 6. This is the kind of insight I was interested in. Maybe you can do something similar.


CREATING A STACKED AREA PIVOT CHART

The example I have used is a Pivot Chart which is different from a standard chart in that the data source is a Pivot Table rather than a standard table. Here are the steps.

1. Create Pivot Table

2. Create 100% Stacked Area Chart

3. Apply Appropriate Filters (month and year)

4. Apply Design Styling

5. Enjoy!

I hope you enjoyed and comment below to let me know what you think.

MORE ARTICLES