Composition > Changing Over Time > Many Periods > Relative/Absolute Differences | Difficulty: Easy
.
TABLEAU
SELECT:
1 Date
0 or more Dimensions
0-2 Measures
→ Show Me → Area Charts
MARKS:
COLOR: add a new Dimension (optional)
FOR STACKED 100% AREA CHART:
Change the Measures > Quick Table Calculation > Percent of Total
WHAT IS A STACKED AREA CHART?
An area chart combines the line chart and bar chart to show how one or more groups’ numeric values change over the progression of a second variable, typically that of time. An area chart is distinguished from a line chart by the addition of shading between lines and a baseline, like in a bar chart.
WHEN TO USE A STACKED AREA CHART
You will use a stacked area chart when you want to track not only the total value, but also want to understand the breakdown of that total by groups. Comparing the heights of each segment of the curve allows us to get a general idea of how each subgroup compares to the other in their contributions to the total.
Source: Chartio
EXCEL
INSERT > CHART > AREA CHARTS > 2D AREA > STACKED AREA