Stacked line chart

A stacked line chart draws several series as lines, with each line added on top of the ones below it. The bottom line shows the first series, the next line shows the first two added together, and so on. The top line is therefore the total of all series.

Use it to show how a total builds up over time and how much each part contributes, for example monthly sales of three product lines, where the top line is total sales. The gap between two lines is the size of one series.

Like a stacked column chart, it works best with a few series. Reading the exact value of one series is harder than on a normal line chart, because you read it as the distance between two lines rather than from the axis. If you need to compare the series with each other rather than see the total, use a line chart instead.

Add a stacked line chart

1. In the designer, open the Charts tab of the Widgets pane and drag Stacked Line Chart onto the dashboard. Resize it as required.
2. On the Assign Data tab, pick the Data source.
3. Add the number to plot to Values and the time field to Category (for a date field, pick the grouping, for example Month).
4. Add the field that makes up the stack to Series (for example Product line). Alternatively, add several values to Values: each value becomes one line in the stack.
5. Name the chart and adjust its look on the Properties tab, then save the dashboard.

Every setting is described in Common chart settings.

Settings worth knowing

Setting	What it does
Show Stack labels value (Properties > Basic Settings)	Shows the total above each point of the top line.
Type (Assign Data > More settings > Series settings)	Stacking Line stacks the actual values. 100% Stacking Line shows each series as a share of 100%, so the top line is always at 100%.
Show Value Labels (Properties > Labels)	Shows each series' own value at its point.