When to use
- Financial analysis - Show income, expenses and profit
- Explaining variance - Break down differences between starting and ending values
- Incremental changes - Display step-by-step contributions
- Budget vs actual - Analyze deviations
Basic example
How it works
Waterfall charts automatically:- Start with the first value as the base
- Show positive values as upward bars (increases)
- Show negative values as downward bars (decreases)
- Connect bars to show the running total
- Display the final cumulative value
Data structure
Provide:- First column: Category labels
- Second column: Numeric values (positive for increases, negative for decreases)
Data labels
Show values on each bar:Related
- Column - Standard column chart
- Data labels - Display bar values