How to Change Axis in Waterfall Chart in Excel

Excel's waterfall chart is a fantastic tool for visualizing how a starting value is affected by a series of positive and negative changes. But you've probably noticed its one major annoyance: the vertical axis doesn't always start at zero, often making the chart's starting point feel like it's floating awkwardly in space. This article walks you through a practical workaround to gain complete control over your waterfall chart's axis, ensuring your data story is both clear and accurate.

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

What Exactly is The Problem?

You carefully prepare your financial data, insert a waterfall chart, and see something like this: your starting revenue bar is hovering in the middle of the chart, and the y-axis starts at some arbitrary number. This happens because Excel's default waterfall chart automatically sets the axis range to best fit the bars, but it doesn't give you a simple "Format Axis" option to set a minimum value of zero.

This is more than a minor cosmetic issue. A floating axis can visually distort the scale and magnitude of changes, potentially confusing your audience. For financial reports, where clarity and trust are paramount, this is a real problem. We want our charts to build confidence, not create questions.

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

First, a Quick Refresher: Creating a Standard Waterfall Chart

Before we dive into the fix, let’s make sure we're on the same page. To create a default waterfall chart in Excel, you typically have data structured in two columns: one for labels (e.g., "Starting Revenue," "New Sales," "Refunds") and one for the values.

1. Organize your data with categories and their corresponding positive or negative values.
2. Select your data range.
3. Go to the Insert tab in the ribbon.
4. Click on Insert Waterfall, Funnel, Stock, Surface, or Radar chart (the icon looks like a small waterfall).
5. Select Waterfall.

Excel generates the chart, but you still need to tell it which bars are totals. Double-click on the "Starting Revenue" bar, right-click, choose Format Data Point, and check the Set as total box. Do the same for your "Ending Revenue" bar. Now you have a basic, functional waterfall chart — along with that problematic floating axis.

The Fix: Build a Better Waterfall with a Stacked Column Chart

The secret to gaining axis control isn't in fighting with the default waterfall chart settings. Instead, we'll build our own visually identical chart using a more flexible chart type: the Stacked Column Chart. This method involves slightly restructuring our data, but it gives us the control Excel's native waterfall chart withholds.

Let's use a sample data set showing monthly cash flow for a small business:

• Beginning Cash: $15,000
• Product Sales: +$8,000
• Marketing Spend: -$2,500
• Salaries: -$5,000
• Interest Income: +$500
• Ending Cash: Total

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

Step 1: Restructure Your Data Table

We need to add a few helper columns to our data table to make this work. Your new table should have these columns:

• Category: Your labels (Beginning Cash, etc.)
• Increase: This column will hold only positive values.
• Decrease: This column will hold only the absolute positive value of your negative changes.
• Base: This is the secret ingredient. It will be an "invisible" bar that positions our visible bars correctly on the chart.
• Start/End: This column will hold our beginning and ending totals.

Your goal is to populate the Increase, Decrease, and Start/End columns from your original values. Here's a set of simple formulas to do it automatically.

Let’s say your categories are in column A and values in column B, starting from row 2.

• Increase (Column C): =IF(B2>0, B2, 0)
• Decrease (Column D): =IF(B2<0, -B2, 0)
• Start/End (Column E): =IF(OR(A2="Beginning Cash", A2="Ending Cash"), B2, 0)

Step 2: Calculate the "Base" Column

The "Base" column is our foundation. It calculates the starting point for each bar so it "floats" to the correct position. The logic is a bit tricky, but the formula is straightforward. If your Start/End data is in column F, then:

=(F2+C2)-D3

But since this varies per row, the general approach is:

• For the first row (Beginning Cash), base is zero.
• For subsequent rows, base is previous base + previous increase – previous decrease.

In practice, you'll create a cumulative formula that builds from the previous total.

Step 3: Insert and Configure the Stacked Column Chart

Now for the fun part.

1. Select your entire data range, including the new helper columns (Increase, Decrease, Base, and Start/End).
2. Go to Insert > Chart > Insert Column or Bar Chart > Stacked Column.
3. Right-click on your chart and choose Select Data.
4. In the Legend Entries (Series) box, make sure the order is:

Step 4: Make the Base Invisible

To shape it into a waterfall:

• Double-click on any of the Blue "Base" bars to select the entire series.
• In the Format Data Series pane, go to Fill & Line.
• Set Fill to No fill.
• The blue bars will disappear, leaving your Increase and Decrease bars floating properly.

Step 5: Connect the Bars

To simulate the flow lines:

• Change the "Start/End" bars to a line chart:

Adjust axis order if necessary, and add connector lines and labels for clarity.

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

Final Tips:

• Color increases green, decreases red.
• Make bars invisible or adjust formatting for professional look.
• Add data labels, titles, and customize axes as needed.

Final Touches for a Chart That Wows

Customize your chart with a professional look:

• Use company colors.
• Remove gridlines or background.
• Add labels and titles.
• Make sure axes start at zero (by customizing axis bounds).

This technique ensures your waterfall charts are clear, accurate, and visually appealing, making your data storytelling much more effective.

The Time to Master New Skills is Today!

Once you've set this up, save your workbook as a template. Future reports can just update raw data, and your waterfall chart will update automatically. This saves time and guarantees a polished, consistent presentation every time.

Conclusion

While it seems involved at first, building a waterfall chart from a stacked column base is straightforward with practice. The main advantages are full control over the y-axis and the ability to tell your data's story as clearly as possible, without floating bars or other default quirks.

We built Graphed so users can create rich visual dashboards instantly, with AI-powered automation. By leveraging smart tools, smaller teams can access powerful data visualization without complex Excel skills. Faster insights, clearer reports — that’s the business advantage in today’s data-driven world.