How to create a stacked area chart showing the % of total

by Edoardo Aversa

Line charts are a useful way to visualise the individual trends over time, but what if we need to visualise the distribution of data as part of a whole over time? In this post we are going to look at a simple and effective possible solution: the stacked area chart (showing the % of total).

From the example below, it is possible to build a stacked area chart to show the contribution - as a percentage - of each Segment to the total Sales (our 100%).

To build the stacked area chart, select Area from the mark types:

We should see the following chart:

Now we need to show the values as a % of total. To do that, right click on the measure (in this case Sales) in the chart, select Quick Table Calculation and Percent of Total:

We should have now changed the y-axis into a percentage; however, as it is now, the result is not really helpful. We need a final step: right click again on Sales and hover over Compute using, then select Table (down):

There you have it! The result should look like this:

Avatar

Edoardo Aversa

Mon 09 Aug 2021