How to Format Waterfall Chart in Excel

A waterfall chart is perfect for telling the story behind a number, showing exactly how you got from a starting value to an ending one. But an unformatted, out-of-the-box Excel chart can be more confusing than helpful. This guide will walk you through the essential formatting steps to make your waterfall charts clear, professional, and easy to understand at a glance.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First Things First: What Exactly is a Waterfall Chart?

A waterfall chart, sometimes called a bridge chart, is a data visualization that shows a running total as values are added or subtracted. It’s ideal for understanding the cumulative effect of a series of positive and negative changes to an initial value.

Imagine you're tracking your company's monthly cash flow. You started the month with a certain amount, gained revenue from sales, paid for expenses like salaries and rent, and ended with a final amount. A waterfall chart visualizes this journey perfectly. Instead of just seeing the start and end points, your audience can see the "journey" in between - the individual contributions that led to the final result.

Common uses include:

• Financial Performance: Breaking down profit drivers from revenue to net income.
• Project Budget Tracking: Showing how an initial budget is affected by various expenses and a final variance.
• Inventory Management: Visualizing changes from starting inventory, additions from production, and subtractions from sales.
• Sales Funnel Analysis: Tracking the drop-off of leads at each stage of a funnel.

Creating the Basic Waterfall Chart in Excel

Before you can format a chart, you need to create one. The key to a successful waterfall chart is structuring your data correctly. You need a column for your categories and a column for the corresponding values. Increases should be positive numbers, and decreases should be negative numbers.

Let's use a simple sales analysis as an example. You want to show how you got from last year's sales to this year's sales.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Set Up Your Data

Arrange your data in two columns. The "start" and "end" values are technically totals, but for now, they go in the same column as your changes.

Your table might look something like this:

Important Note: For the "This Year's Sales" value, you would typically use a SUM formula to calculate this from the other values to ensure accuracy.

Step 2: Insert the Chart

Once your data is ready, creating the initial chart is straightforward.

1. Click and drag to select your entire data table (including the headers).
2. Navigate to the Insert tab on Excel’s ribbon.
3. In the Charts group, click the icon for "Insert Waterfall, Funnel, Stock, Surface, or Radar chart." It looks like a small waterfall chart.
4. From the dropdown menu, select Waterfall.

Excel will instantly generate a basic waterfall chart. Right away, you’ll notice a problem: the start and end bars ("Last Year's Sales" and "This Year's Sales") look the same as the increases and decreases. They float instead of grounding the chart from the axis. This is where formatting becomes essential to telling the right story.

Essential Formatting for Clarity and Impact

An effective waterfall chart relies on a few key formatting techniques to guide the viewer’s eye and make the data’s story intuitive. Let’s clean up that raw chart.

1. Highlight the Totals (The Most Important Step)

The first and most critical move is to designate your starting and ending bars as "totals." This anchors them to the horizontal axis, visually separating them from the positive and negative changes that float in between.

1. Click once on the first bar in your chart ("Last Year's Sales") to select just that bar. If you select all the bars, just click the bar you want again.
2. Right-click on the selected bar to open the context menu.
3. Choose "Set as Total." The bar will immediately drop to touch the axis and change color (usually to grey).
4. Repeat the process for your ending bar ("This Year's Sales"). Click the final bar once to select it, right-click, and select "Set as Total."

This single change is a game-changer. Your chart now has a clear beginning and end, making the "bridge" of gains and losses instantly understandable.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

2. Apply a Color Scheme That Tells a Story

Color is a powerful tool for visual storytelling. By default, Excel uses a standard color for increases and a different one for decreases. To make your chart even clearer, use conventional financial colors: green for good (increases), red for bad (decreases), and a neutral color like blue or grey for totals.

Let's color our chart to follow this logic.

• Formatting Increases (Green): Click once on any "Increase" bar (e.g., "New Accounts"). This will select all the bars of the same type. Right-click and choose Format Data Series. In the pane that opens on the right, go to the Fill & Line (paint bucket) icon. Under Fill, select the green fill for all positive values.
• Formatting Decreases (Red): Now, click on a "Decrease" bar ("Churn"). Right-click, go to Format Data Series, choose the Fill & Line icon, and select red for all negative values.
• Formatting Totals (Blue or Grey): Excel usually colors totals grey by default. If your version doesn't, or you prefer a different color like a corporate blue, you can change it. Click a "Total" bar, right-click, go to Format Data Series, and pick your neutral color.

This simple color coding removes any ambiguity. Anyone looking at your chart knows immediately that green items helped your sales grow and red items hurt it.

3. Improve Data Labels and Axes for Readability

Raw numbers pasted on a chart aren't helpful if they're cluttered or hard to read. A little cleanup on your labels and axes can make a world of difference.

Cleaning Up Data Labels

Data labels show the exact value of each increase or decrease. You can add them and then format them to be more legible.

1. Click on your chart to select it.
2. Go to the Chart Design tab. On the far left, click Add Chart Element > Data Labels > Outside End or another position you prefer.
3. The default labels might look messy. Right-click on any of the new data labels and choose Format Data Labels. In the settings pane, you can adjust the label position, but more importantly, you can change the number format.
4. Under Number, you can set the format to "Currency" and reduce the decimal places to 0 for a cleaner look (e.g., showing "$30,000" instead of "30000.00").

Formatting the Vertical Axis

Sometimes Excel chooses a maximum value on your vertical axis that leaves too much blank space at the top of your chart. You can manually adjust this.

1. Right-click the vertical axis (the numbers on the left side of the chart).
2. Select Format Axis.
3. In the Axis Options, you can adjust the Bounds. If your highest point is 150,000, you might set the Maximum bound to 160,000 instead of the automatic 200,000, making the chart feel more filled out and substantial.
4. You can also apply number formatting here, just like you did for the data labels.

4. Tweak Connector Lines

Connector lines are the faint dotted lines that visually link the end of one bar to the beginning of the next. Normally, you don't need to change them, but if they feel too intrusive or not visible enough, they're easy to format.

1. Click on your data series to select all the up/down bars.
2. Go to the Format tab or right-click and find Format Data Series.
3. Under the Series Options, look for a checkbox called Show connector lines. It should be checked.
4. Next, navigate to the Fill & Line (paint bucket) section. You will see line formatting options where you can change the color (a light grey is usually best), width, and dash type of a Connector Line, making the visual connection between your values flow perfectly.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

5. Write a Clear Title and Adjust the Legend

Finally, no chart is complete without a title that explains what the viewer is looking at. "Chart Title" doesn't help anyone.

• Add a Descriptive Title: Double-click the default chart title text box. Replace it with something specific and informative, like "Q3 Sales Performance: Bridge from FY22 to FY23" or "Monthly Cash Flow Analysis - October 2024". A good title provides immediate context.
• Position the Legend: Excel automatically adds a legend for "Increase," "Decrease," and "Total." Usually, this is helpful. You can move it to a better position (e.g., top or bottom) by clicking the chart, heading over to Chart Design > Add Chart Element > Legend and choosing a new location. Or, if your colors are self-explanatory, you can delete the legend entirely to free up space.

Advanced Tip: Saving Your Chart as a Template

Once you’ve perfected your waterfall chart format - with your company’s brand colors, ideal number formatting, and preferred layout - you don’t have to do it all again every time. You can save it as a template.

1. Right-click the border of your fully formatted chart.
2. Select Save as Template...
3. Give it a descriptive name like "Waterfall Finance Chart" and save it.

The next time you need to create a waterfall chart, you can insert your data, go to Insert > All Charts, click on the Templates tab, and your perfectly formatted chart style will be there waiting for you, saving you valuable time.

Final Thoughts

Formatting a waterfall chart in Excel transforms it from a generic and potentially confusing graphic into a compelling visual story. By setting your totals, using a clear color scheme, and tidying up labels and axes, you can create a professional-grade chart that clearly communicates the factors driving change in your business metrics.

And if you want to skip the manual work of exporting CSVs and formatting charts in Excel altogether, we've designed Graphed to automate the entire process for you. You can connect your live data sources like Google Analytics, Shopify, or Salesforce, and just ask for the report you need in plain English - like "create a waterfall chart showing this month's revenue, broken down by new sales, renewals, and refunds." We'll instantly generate a real-time, interactive chart for you, saving you the steps of wrangling data and formatting it manually.