How to Create a Stacked Waterfall Chart
Data Format
One row per step, same as a regular waterfall. Add a second value column to split each step into components.
| Category | Value | Value 2 |
|---|---|---|
| Starting Revenue | 120 | 0 |
| Q2 Change | 12 | 18 |
| Q3 Change | -8 | 25 |
| Ending Revenue |
- Category (required): the label shown under each bar.
- Value, Value 2 (required to add or subtract): each column is one component of that step's change. Add more value columns to split a step into more components.
- A row counts as a subtotal or the final total only when every value column on that row is blank. If even one column has a number, the row renders as a normal segmented step.
Chart Elements
A stacked waterfall uses the same style panel as a regular waterfall, see the Waterfall Chart guide for the connector, axes, gridlines, and axis labels. What changes with multiple value columns:
Bars
Each value column gets its own pair of colors, labeled by its column name.
- Positive / Negative - one color pair per value column.
- Total - one shared color for subtotal and total bars, across all columns.
- Bar Width - width of every bar.
Legend
Appears automatically once a step has two or more value columns. With only one value column there's nothing to show, so the legend stays empty even if it's turned on.
- Color - legend text color.
- Font / Font Size - legend text styling.