Deviation Waterfall Charts

Deviation Waterfall Charts are a specialized type of waterfall chart that can be added on top of an existing chart to highlight deviations over time or between categories. These charts focus on visualizing deviations, accumulating them to make it easier to see how individual elements contribute to the overall deviation from a baseline. Each bar in a deviation waterfall chart represents a deviation, with the cumulative effect clearly displayed.

Deviation Waterfall Charts are particularly useful for analyzing variance in performance metrics, budget vs. actual comparisons, and identifying areas of overperformance or underperformance.

For a detailed explanation on how to set up and use deviation charts, please refer to Adding Deviation Charts and Changing Deviation Chart Types.

Below is an example illustrating a deviation waterfall chart, showing cumulative deviations over a series of periods:

Deviation Waterfall (on the right)