✦Template Printable Ideas Insights

Master Excel: Create Simple Waterfall Chart in 3 Steps

By

The art of data visualization can help transform complex numbers into insightful, easily understandable information. One way to achieve this is by using a waterfall chart in Excel. This visual tool enables you to break down the total change into its individual parts, like a waterfall, hence the name. Let's explore how to make a simple waterfall chart in Excel step by step.

Before we dive into the creation process, make sure you have the Microsoft Office suite installed on your computer. This article uses Excel 2013, but the steps are similar in other recent versions.

Setting Up Your Data

The first step is to organize your data. A waterfall chart compares the cumulative total of series items. This means that each category should have both its positive and negative contributions toward the total, not just the final sum.

How to create waterfall chart in Excel
How to create waterfall chart in Excel
Excel Waterfall Charts (Bridge Charts) - Peltier Tech
Excel Waterfall Charts (Bridge Charts) - Peltier Tech
Waterfall Chart Template
Waterfall Chart Template

Let's take an example: You want to visualize the monthly revenue of a company. Your data might look like this:

MonthRevenueExpenses
Jan5000015000
Feb6000020000
Mar7500012000

Transforming Your Data

To prepare your data for the waterfall chart, you'll create a new column for the cumulative total. Here is the same table, but with the cumulative total added as the first column:

How to create waterfall chart in Excel
How to create waterfall chart in Excel
Interactive Waterfall Chart Dashboard - Excel Campus
Interactive Waterfall Chart Dashboard - Excel Campus
Excel Waterfall Chart - Tutorial and Template - Learn how to make waterfall charts using MS Excel
Excel Waterfall Chart - Tutorial and Template - Learn how to make waterfall charts using MS Excel
MonthPrevious Month Cumulative TotalRevenueExpensesThis Month Cumulative Total
Jan-500001500035000
Feb35000600002000070000
Mar700007500012000103000

Setting up your data this way exaggerates the total change, but it makes the individual components easier to understand.

Using Excel's Built-in Waterfall Chart

Excel 2016 and newer versions have a built-in waterfall chart feature:

  • Select your data, including the headers.
  • Click on the "Insert" tab.
  • In the "Charts" group, click on the "Waterfall" button.
  • Choose the "Waterfall" layout.

The resulting chart should look something like this:

Create an Excel 2016 Waterfall Chart | MyExcelOnline
Create an Excel 2016 Waterfall Chart | MyExcelOnline
Waterfall Chart Infographics for Google Slides and PowerPoint
Waterfall Chart Infographics for Google Slides and PowerPoint
Waterfall Chart in Excel📚
Waterfall Chart in Excel📚
5-Second Video Manual How to Create Waterfall Chart in Excel
5-Second Video Manual How to Create Waterfall Chart in Excel
How to Create a Waterfall Chart in Excel 2016
How to Create a Waterfall Chart in Excel 2016
Waterfall graphs
Waterfall graphs

Waterfall chart example

Customizing Your Chart

Of course, a default chart is only a starting point. Excel offers a variety of customization options to make your waterfall chart truly your own.

Adding a Title

Adding a title to your chart helps readers understand its purpose. Here's how:

How To Create a Waterfall Chart in PowerPoint and Excel | Professional PowerPoint Templates Slides
How To Create a Waterfall Chart in PowerPoint and Excel | Professional PowerPoint Templates Slides
How to Create a Waterfall Chart in Excel?
How to Create a Waterfall Chart in Excel?
How to Create a Waterfall Chart in Excel
How to Create a Waterfall Chart in Excel
  • Click anywhere in your chart to activate the "Design" tab.
  • In the "Chart Layouts" group, choose a layout that includes a chart title (e.g., "Add Chart Element | Chart Title").
  • Type in your title, and then adjust the font, color, and other formatting options as needed.

Switching Rows and Columns

Excel's built-in waterfall chart switches months and totals, so they're not in the same order as the data. If you'd like to swap them, you can:

  • Click anywhere in your chart.
  • In the "Design" tab, click on "Switch Row/Column".

Following these steps, you'll have a clean, well-organized, and informative waterfall chart that effectively communicates your data. Now you can use this new skill to create compelling visuals that help drive informed decision-making. Happy charting!