How to Make a Waterfall Chart in Tableau

Creating a waterfall chart in Tableau is the perfect way to visualize how individual positive and negative values build up to a final total. It’s a powerful tool for telling a clear, step-by-step story with your data, whether you're breaking down quarterly profits or analyzing budget variance. This guide will walk you through exactly how to build a dynamic and insightful waterfall chart from scratch.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Waterfall Chart?

Before we build one, let's quickly cover what a waterfall chart does. Think of it as a visual running tally. It shows a starting value, a series of increases and decreases that occur over time or between categories, and the resulting ending value. The “floating” bars in the middle seem to hang in mid-air, connected by thin lines that show the cumulative progression, resembling a cascade of water.

They are especially useful for:

• Financial Analysis: Breaking down a company's profit and loss statement, showing how revenue is affected by various costs to arrive at net income.
• Inventory Tracking: Starting with beginning inventory, adding purchases, and subtracting units sold to get the ending inventory.
• Budget vs. Actual Variance: Visualizing how different expense categories contributed to over- or under-spending relative to the budget.
• Sales Performance: Showing how contributions from different regions or representatives add up to a total sales figure.

Preparing Your Data

To create a waterfall chart, your data only needs two things:

1. A dimension that categorizes your data. These will be the "steps" in your waterfall. For a financial report, this could be "Revenue," "Cost of Goods Sold," "Marketing Expenses," "Salaries," etc.
2. A measure that contains the numerical values for each category. For our financial example, this would be the actual dollar amount for each line item. It's crucial that negative values are truly negative (e.g., -5,000 for an expense).

For this tutorial, we’ll use the Sample - Superstore dataset included with Tableau, visualizing how the different product Sub-Categories contributed to the total Profit.

Building Your Waterfall Chart: A Step-by-Step Guide

Building a waterfall chart in Tableau might seem tricky, but it’s really just a clever combination of a Gantt chart and a running total calculation. Let’s create it step-by-step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get the Basic Structure in Place

First, we need to set up the foundation of our chart. Open a new worksheet in Tableau and connect to the Sample - Superstore data source.

• Drag the dimension you want to analyze, Sub-Category, onto the Columns shelf.
• Drag the measure you want to track, Profit, onto the Rows shelf.

You’ll have a standard bar chart showing the profit for each sub-category. Some bars will go up (positive profit), and some will go down (negative profit). This is our starting point.

Step 2: Change the Mark Type to a Gantt Bar

This is where the magic starts. The foundation of a Tableau waterfall chart isn't a bar chart at all - it's a Gantt chart.

• In the Marks card (just to the left of your visualization), click the dropdown menu and change the mark type from "Automatic" (which is currently "Bar") to Gantt Bar.
• You’ll see your chart change into a series of thin horizontal lines all sitting at the zero axis. Don't worry, this is exactly what's supposed to happen. Gantt bars are basically markers - we just need to tell Tableau their starting point and how big to make them.

Step 3: Create a Calculated Field for the Bar Size

Look at the Gantt Bar mark you just created. It has channels for Position, Color, Size, Label, etc. To make our waterfall chart work, we need to tell Tableau how large each bar should be. The size should represent the profit for that Sub-Category.

However, we want the size to always be a positive number that pulls the bar either up or down. A bar can't have a negative size. We accomplish this by calculating the negative value of our measure.

• Navigate to the top menu and select Analysis > Create Calculated Field.
• Name this new field something intuitive, like Negative Profit.
• In the formula box, simply type:

-[Profit]

• Click OK.

Now, drag your new Negative Profit calculated field onto the Size card in the Marks shelf. You'll see bars appear, some going up and some going down from the zero line. We’re getting closer!

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Create the "Steps" with a Running Total

This is the key step. We need to position each Gantt bar so that it starts where the previous one left off. This creates the cumulative "waterfall" effect. We do this using a running total table calculation on our main Profit measure.

• In the Rows shelf, right-click the SUM(Profit) pill.
• From the context menu, select Quick Table Calculation > Running Total.

Your chart will immediately transform into a waterfall chart! The running total calculation cumulatively adds the profit (or loss) from each sub-category, telling each Gantt bar where to begin. The Negative Profit on the size shelf tells it how far to extend up or down from that starting point.

Refining Your Tableau Waterfall Chart for Clarity

You have a functional waterfall chart, but let's make it more professional and easier to read with a few quick enhancements.

Add Meaningful Colors

Color is a great way to quickly distinguish between positive and negative contributions. Let's color the bars green for profit and red for a loss.

• Drag the original Profit measure from the Data pane onto the Color card in the Marks shelf.
• Click the Color card to edit the colors.
• Choose a diverging palette, like "Red-Green Diverging."
• Click "Advanced," check the "Stepped Color" option, and set it to 2 steps. This ensures you only get two distinct colors: one for positive and one for negative. Set your center to 0. Now all positive values are one color and all negatives are another.

Add a Grand Total Bar

A waterfall chart is often incomplete without a total bar at the end to show the final result. Tableau makes this very simple.

• Go to the top menu and select Analysis > Totals > Show Row Grand Totals.

A new bar labeled "Grand Total" will appear on the far right of your chart, representing the final cumulative profit across all sub-categories. You'll likely need to format this bar differently so it stands out. Often, people want this bar to start from the zero axis and go up to the final total. To keep it simple, simply adding the column total gives you the endpoint, which is the most critical piece of information.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Display Values with Data Labels

Let's add labels to show the magnitude of each change.

• Grab the original Profit measure from your Data pane again.
• Drag it onto the Label card in the Marks shelf.
• The labels might not be positioned perfectly. You can click on the Label card to adjust alignment and formatting to make them more readable. For waterfall charts, aligning labels to the middle or top/bottom of the bars works well.

With these enhancements, your chart is not just functional, it's a presentation-ready visual that clearly communicates the story behind your numbers.

When Should You Use a Waterfall Chart?

Waterfall charts are fantastic storytellers, but only for the right kind of story. They excel when you need to show how a value is affected by a series of sequential positive and negative changes.

Some perfect use cases include:

• Profit Analysis: Start with Gross Revenue, then subtract COGS, Marketing costs, R&D, etc., to arrive at Net Profit.
• Cash Flow Statement: Show how starting cash is affected by operating, investing, and financing activities to determine ending cash.
• Headcount Changes: Start of Quarter Employees + New Hires - Departures = End of Quarter Employees.

However, avoid waterfall charts for comparing the standalone values of many categories. A simple bar chart is much more effective for that. The waterfall is for explaining the journey, not just the final destination.

Final Thoughts

Building a waterfall chart in Tableau is a fantastic skill to add to your data visualization toolkit. By combining a Gantt Bar mark with a running total calculation, you can turn a simple table of data into a compelling visual story that explains how different components add up to a final result.

While mastering tools like Tableau is incredibly powerful, sometimes you just need a quick answer without getting into the weeds of calculated fields and table calculations. With Graphed , we’ve made creating complex reports as simple as asking a question. Instead of following multiple steps, you can just ask, "Show me a waterfall chart of profit broken down by sub-category for last year." We automate the analysis and build the visuals so you can focus on the insights, not the setup.