• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Waterfall Chart in Excel

August 9, 2021 by Andrew Childress
Waterfall chart in Excel

Running totals are often used in financial applications to track increases and decreases in a balance. Let’s learn how to add a waterfall chart in Excel.

Running totals are often used in financial applications to track increases and decreases in a balance. They also work well for many other uses. However, running totals can be somewhat confusing to follow if they’re simply presented as numbers. Fortunately, Excel offers a tool called a waterfall chart to visually illustrate running totals. Let’s learn how to add a waterfall chart in Microsoft Excel.

How to Add a Waterfall Chart in Microsoft Excel

Imagine that you have a business, and you want to visually illustrate your current cash balance based on a series of inflows and outflows. For example, you’re starting with $25,000, and plan to take in $31,000 in sales and $2,000 in bonus income. However, you’ll also be spending $18,000 in expenses. A visual aid in the form of a waterfall chart would help illustrate this.

To start adding a waterfall chart in Excel, begin by inputting your data in a basic layout like this. Inflows are positive numbers, while outflows are listed as negative numbers.

Waterfall chart in Excel

Once you’re finished, click and drag to select your data. In this example, it’s contained in cells A1:B4. With the data selected, find the Insert tab up on Excel’s ribbon, and click on it.

Near the center of the Insert tab, in the Charts group, find the Waterfall dropdown button and click on it. Excel will display an array of chart thumbnails. You’ll want to choose the one at the top – again, labeled Waterfall. Click on it.

Add waterfall chart in Excel

Excel will automatically insert a waterfall chart onto your spreadsheet. As you can see, it’s an easy visual way to track a running total. With vivid color tones and clear labels, it makes your numbers much easier to understand.

Insert waterfall chart in Excel

Waterfall charts are an amazing way to track running totals, and by using Microsoft Excel, you can draw them in moments. Give them a try next time you have a balance to illustrate.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Change text color in ExcelChange Text Color in Excel
Next Post:How to Move Worksheets in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top