🏞️Waterfall Chart

NEW

Also known as: Bridge Chart

A bar-based chart showing sequential positive and negative contributions to a cumulative total across categories or time.

DESCRIPTION

A waterfall chart visualizes how incremental changes add up from a starting value to an ending value. It’s widely used for financial bridges, variance analysis, and contributions by category. Each bar shows a step change, with subtotals and totals highlighted. Proper color encoding distinguishes increases and decreases. It clarifies drivers of change and aids stakeholder communication. Avoid clutter and ensure category order reflects logical sequence.

ALTERNATIVE DEFINITIONS

Wikipedia

A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values.

Highlights cumulative effects of sequential values.

Source

Microsoft

A waterfall chart shows a running total as values are added or subtracted, helping visualize how an initial value changes with contributed values.

Emphasizes running totals and contribution visualization.

Source

Tableau

A waterfall chart visually breaks down the cumulative effect of sequential positive and negative values to show how a starting value becomes a final value.

Step-by-step breakdown for practical creation and interpretation.

Source

RELATED TERMS

Bar Chart Variance Analysis Contribution Analysis Temporal Data Financial Reporting Decomposition Dashboard Power BI Tableau

COMPETING TERMS

Stacked Bar Chart

RELATIONS

• Broader: Chart

KNOWLEDGE AREAS

Data Visualization Data Warehousing & BI Data Science

TARGET AUDIENCE

BI Specialist Data Analyst

EXTERNAL SOURCES

• Wikipedia - Waterfall chart
• Microsoft - Power BI waterfall chart guidance
• Highcharts - Waterfall chart API details
• Apache ECharts - Waterfall series configuration

TOP QUESTIONS

When should I use a Waterfall Chart?

Use it to explain how a starting metric changes through sequential increases and decreases to reach an ending value.

Category: Application

What are common mistakes with Waterfall Charts?

Poor ordering of categories, ambiguous color schemes, and missing totals can confuse interpretation.

Category: Mistakes

How do Waterfall Charts differ from Stacked Bars?

Stacked bars show composition within categories; waterfalls show sequential change and running totals over steps.

Category: Comparison

What is a hot topic in Waterfall Chart usage?

Interactive bridges that allow drill-down into drivers are increasingly popular in BI tools.

Category: Topic

How should increases and decreases be encoded?

Use consistent colors (e.g., green for increases, red for decreases) and clear legends for accessibility.

Category: Best Practice

Can Waterfall Charts represent time-based changes?

Yes, ordering by time shows period-to-period contributions leading to a final value.

Category: Application

How do I present subtotals in a Waterfall Chart?

Use distinct bars or labeled markers for intermediate totals to guide readers.

Category: Best Practice

What data is required for a Waterfall Chart?

A starting value, a sequence of signed contributions, and an ending value, plus optional subtotals.

Category: Requirements

How can Waterfall Charts mislead?

If steps are cherry-picked or reordered, the narrative can be skewed. Maintain transparency and consistent logic.

Category: Risks