Stacked Area Chart

Composition > Changing Over Time > Many Periods > Relative/Absolute Differences | Difficulty: Easy
.

TABLEAU

SALES BY ORDER DATE & SEGMENT

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?

STACKED
STACKED 100%

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

ITEM SALES BY FISCAL YEAR

INSERT > CHART > AREA CHARTS > 2D AREA > STACKED AREA

Design a site like this with WordPress.com
Get started