How to Make a Waterfall Chart with AI

A waterfall chart is one of the best ways to tell the story of your data - visualizing how a starting value increases or decreases over time to reach a final total. This article explains what they are, why the old way of making them is so painful, and how you can now create one instantly with AI by asking a simple question.

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 is a Waterfall Chart, Anyway?

Imagine you want to see how your company's bank account balance changed over the month. You started with $50,000. You added $30,000 from sales. Then you subtracted $10,000 for rent, $15,000 for salaries, and $2,000 for software subscriptions. You ended the month with $53,000.

A waterfall chart (sometimes called a bridge chart) perfectly visualizes this story. It shows the starting "pillar" of $50k, followed by a green "floating" bar going up for sales, several red "floating" bars going down for each expense, and a final pillar showing the ending balance of $53k.

This "flow" format makes them incredibly useful for telling a clear financial story. You can instantly see which factors had the biggest positive and negative impacts. This is why they are a favorite for:

• Financial Reporting: Tracking profit and loss, explaining changes in revenue, or visualizing cash flow.
• Sales Pipeline Analysis: Showing how you started with a certain number of leads, lost some to disqualification, gained some back from reactivation, and ended with a final number of closed deals.
• Inventory Management: Visualizing starting inventory, adding new stock, subtracting sold items and damaged goods, and arriving at the ending stock count.
• Budget vs. Actuals: Starting with a project budget, showing where you overspent and underspent, and ending with the final project cost.

The Old Way: Wrestling with Spreadsheets and BI Tools

For something so useful, building a waterfall chart has traditionally been a frustrating experience. Your two main options were spreadsheets or traditional business intelligence tools, each with its own set of challenges.

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

Making a Waterfall Chart in Excel or Google Sheets

Spreadsheet tools don't have a one-click "waterfall chart" option. To build one, you have to use a clever but complicated workaround involving a stacked column chart. It feels more like a science project than a simple data visualization task.

The process generally looks like this:

1. Set up your data table: You need columns for your categories (e.g., "Starting Revenue," "New Sales," "Refunds," "Ending Revenue") and the corresponding values. This part is simple enough.
2. Create "helper" columns: Here's where it gets messy. You need to create extra columns that aren't part of your original data. A typical setup includes columns for "Base" (the invisible bar that lifts your data into place), "Increase" (for positive numbers), and "Decrease" (for negative numbers).
3. Write complex formulas: You have to populate these helper columns with formulas that calculate a running total. For the "Base" column, a formula might look something like this in each cell:

=A1-B1-C1

This formula seems simple, but its logic across an entire table and its dependency on the rows above it makes it incredibly sensitive. One wrong formula and the entire chart breaks.

1. Build a Stacked Column Chart: You then insert a stacked column chart using these new helper columns, not your original data.
2. Format everything manually: The chart you get won't look like a waterfall chart yet. You'll need to manually select the "Base" series in your chart and make it invisible by setting its fill to "No Color." Then you format the start and end pillars to look like full columns and color-code your increase/decrease bars (e.g., green for up, red for down).

This process is not only time-consuming but also extremely prone to error. A single slip-up in a formula can throw off the entire visual, leading to hours of frustrating troubleshooting. It requires a level of spreadsheet mastery that most business professionals simply don't have (or want).

Using a Traditional BI Tool (Tableau, Power BI, etc.)

Modern BI tools like Tableau and Power BI have made this process easier. Most of them include waterfall charts as a standard visualization type, removing the need for manual formula creation. However, the learning curve is still steep.

Even with a dedicated tool, you still have to:

• Connect and prepare your data source.
• Navigate the complex interface to find the right chart options.
• Drag and drop the correct dimensions and measures into the right fields.
• Spend time configuring settings to make the increases, decreases, and totals appear correctly.

While faster than using a spreadsheet, it’s far from intuitive. It requires you to learn the specific language and workflow of that tool, which can take days or even weeks to feel comfortable with.

The New Way: Create a Waterfall Chart by Simply Asking for It

AI-powered analytics platforms have completely changed the game. Instead of building charts with formulas or navigating complex interfaces, you can now just describe the chart you want in plain English. The AI does all the heavy lifting for you.

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: Connect Your Data

First, you need to give the AI access to your numbers. AI data tools connect directly to the platforms where your data lives. For most businesses, this means connecting to tools like:

• Accounting Software: QuickBooks, Xero
• CRM: HubSpot, Salesforce
• E-commerce Platforms: Shopify, Stripe
• Ad Platforms: Google Ads, Facebook Ads
• Spreadsheets: Google Sheets, Excel

This setup process typically takes only a few minutes. You connect your account once, and the AI can securely access your real-time data from that point forward without you ever needing to export another CSV file.

Step 2: Ask a Question in Plain English

Once your data is connected, you can start asking questions just like you would with a human data analyst. There's no code or special syntax to learn. You just type what you want to see.

Here are a few examples of prompts you could use:

For Financial Analysis:

“Create a waterfall chart showing our monthly P&L for January. Start with total revenue, then subtract the cost of goods sold, marketing expenses, and operating costs to show our net profit.”

For Sales Pipeline Tracking:

“Show me a waterfall chart for our sales pipeline this quarter. Start with new MQLs, subtract unqualified leads, and show the final number of closed-won deals from Salesforce.”

For E-commerce Revenue:

“Make a waterfall chart of Shopify performance last month. Begin with gross sales, then show deductions for discounts and refunds to arrive at net sales.”

The AI understands the intent behind your words. It knows "deductions" and "subtract" mean negative changes, and it automatically structures the chart, pulls the correct data, and visualizes it for you in seconds.

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 3: Refine and Drill Down with Follow-Up Questions

The initial chart is just the start. The real power of using AI is how easy it is to dig deeper. Your chart might spark a new question, and with a conversational interface, you can get an answer immediately.

For instance, after seeing your P&L chart, you could ask:

• "This is great. Can you break down the 'Marketing Expenses' bar into its sub-components from Google Ads and Facebook Ads?"
• "What was the single largest expense category last month?"
• "Change the view to show me this same waterfall for last quarter instead of last month."

This back-and-forth interaction lets you explore your data fluidly, following your natural train of thought. Instead of spending 30 minutes rebuilding a chart in Excel to answer a follow-up question, you can get the answer in 30 seconds. This transforms your waterfall chart from a static report into a dynamic tool for analysis and discovery.

Why AI Is a Better Way to Visualize Data

Adopting an AI-first approach for creating visualizations like waterfall charts offers a few clear advantages over traditional methods:

• Unmatched Speed: What used to be a 45-minute task in Excel now takes less than a minute. You can answer business questions at the speed you think of them.
• Accessible to Everyone: You no longer need to be a spreadsheet expert or a trained BI user to build powerful visualizations. If you can ask a question, you can analyze your data. This empowers everyone on your team - from marketers to founders - to make data-driven decisions.
• Fewer Errors: By automating the data connection and chart-building process, you eliminate the risk of human error from typos in formulas or incorrect data selection. The AI pulls directly from the source, so you can trust the numbers.
• Promotes Curiosity: Since it costs nothing in terms of time or effort to ask a follow-up question, you’re more likely to explore. This leads to deeper insights and a better understanding of the story your data is telling.

Final Thoughts

Waterfall charts are exceptional tools for communicating the story of how and why a value has changed. They bring clarity to everything from monthly financials to sales pipelines, but their traditional complexity has often kept them out of reach for non-analysts. Now, that barrier has come down.

At Graphed you can build your platform to solve this exact problem. Turning business questions into clear, actionable insights shouldn't require courses in Excel or expensive, complicated analysis tools. We enable you to connect your sales and marketing data in just a few clicks, then use normal language to build live, interactive dashboards. You can get that perfect waterfall chart of campaign ROI or sales performance just by asking for it, saving you hours of manual work and helping you get to the important insights faster.