Waterfall Chart Google Sheets: A Quick Guide

Published: December 16, 2023 - 4 min read

Hannah Recker

Waterfall charts are indispensable in business analytics for visualizing sequential financial changes. Particularly for B2B SaaS companies, they provide clarity on complex data like revenue streams, expenses, and customer metrics.

This guide will walk you through creating a waterfall chart in Google Sheets, using business operations data as an example.

Understanding Waterfall Charts

Fundamentals of Waterfall Charts

Waterfall charts are a type of data visualization that helps demonstrate how a value is affected by a series of positive and negative changes.

These charts are typically used for displaying the cumulative effects of different items, such as financial gains and losses or budget changes over time.

In Google Sheets, you can create a waterfall chart by setting up your data in a specific format and selecting the appropriate chart type.

The basic structure of a waterfall chart consists of:

  • A starting point (initial value)
  • A series of increases and decreases (changes)
  • An ending point (final value)

When setting up your data in Google Sheets, follow these steps:

  1. Use the first column to list the categories or points in time (e.g., quarters or months)
  2. Use the second column to enter the numeric data corresponding to each category (positive or negative values)

Note: It is essential to have the starting and ending values in your data set.

Interpretation of Waterfall Charts

Interpreting a waterfall chart involves understanding the relationships between the starting value, the individual changes, and the end value.

Each bar on the chart represents a change, with positive values displayed as rising bars and negative values as falling bars. The chart is meant to provide a clear, easy-to-read visual representation of how multiple changes accumulate over time.

Some key points to remember while interpreting a waterfall chart include:

  • Positive changes are represented by rising bars, while negative changes are represented by falling bars.
  • The sequence of bars is crucial, as it shows the progression of changes over time or across categories.
  • The ending point represents the cumulative effect of all changes applied to the starting point.

Creating Waterfall Charts in Google Sheets

Getting Started

Before creating a waterfall chart, it’s essential to have your data organized in a way that makes sense for this chart type.

Typically, you’ll have a starting value, followed by a series of positive or negative incremental values, and finally, an ending value that represents the sum of all previous values.

Here’s an example of how your data might look in Google Sheets:

Setting up data in Google Sheets for a waterfall chart, showing initial revenue, subsequent changes, and final net revenue.

Step-By-Step Creation

Once your data is ready, follow these steps to create a waterfall chart in Google Sheets:

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

  1. Select your data: Click and drag to highlight the data you want to include in your chart. Make sure to include both the descriptions and the values.
Selecting data in Google Sheets for waterfall chart creation.

2. Insert a chart: With your data selected, go to the top menu, and click on “Insert” > “Chart.” This will open the Chart editor in the right sidebar.

 Inserting al chart in Google Sheets.

3. Choose the Waterfall chart type: In the Chart editor sidebar, under the Setup tab, click on the “Chart type” drop-down box.

Scroll down and select the “Waterfall” chart type under “Other” option.

Inserting a waterfall chart in Google Sheets

Your chart should now appear in the sheet, visually representing the data you selected.

4. Customize your chart: Navigate to the Chart editor and select the Customize tab.

Customizing the waterfall chart in Google Sheets

Here, you’ll find several customization options, such as changing the chart title, style, and colors.

Spend some time adjusting the settings according to your preferences.


By following these steps, you should now have a well-structured, visually appealing waterfall chart in Google Sheets. Remember that you can always update your data, and the chart will dynamically adjust to represent these changes.

To further enhance your data analysis, consider integrating live data from business solutions using Coefficient. Get started today for free!

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies