Future-Proof Your Career, Master Data Skills + AI

Blog

Blog

# Excel Waterfall Chart: Guide to Create, Design & Impress

by | 8:48 pm EST | January 30, 2024 | Excel

Have you heard of an Excel waterfall chart but are unsure how to create one and make it stand out?

Well, you’re in the right place.

This chart type is particularly useful for displaying financial data, such as profit and loss statements or balance sheets, where it can effectively illustrate the “flow” of positive and negative values.

To create a waterfall chart in Excel:

1. Arrange your data in columns with the base value, increases, and decreases.

2. Select the data and go to the ‘Insert’ tab.

3. Click on ‘Waterfall’ chart under the chart options.

Excel will automatically create the waterfall chart, which you can then customize as needed.

But, there is more to it.

In this article, we’ll provide a step-by-step guide to creating a Waterfall Chart in Excel, complete with examples and tips for customization.

So, whether you’re a beginner or a seasoned Excel user, you’ll find the information you need to produce professional and insightful Waterfall Charts for your data.

Let’s dive in!

## What is a Waterfall Chart?

A waterfall chart is a data visualization tool that shows how positive and negative values in a dataset affect the cumulative total. It is useful for understanding the effect of different variables on a total value over time or across categories.

The chart is called a waterfall chart because the columns appear to float above or below the previous ones, creating a “waterfall” effect. They are also sometimes referred to as bridge charts.

The following is an example of a typical waterfall chart:

## 3 Steps to Make a Waterfall Chart in Excel

In this section, we will go over 3 steps to creating waterfall charts in Excel.

The steps are given below:

### Step 1: Prepare the Data

Ensure your data is structured, such as separate columns for time, increase in quantity, decrease in quantity, and net change.

Your data should look something like the following:

### Step 2: Select The Data

Highlight the data range you want to include in the chart.

In our case, this would be the Month and Net Change columns.

### Step 3: Insert Waterfall Chart

Go to the Insert tab in the Excel ribbon.

Click on the Waterfall chart icon found in the Charts group.

Excel will generate a default waterfall chart.

Now, you can adjust the chart elements, layout, and style as needed. You can also change the starting and ending data points by restricting the range of your cells.

The horizontal axis represents time, whereas the vertical axis represents net change.

### Step 4: Customizing The Chart

You can customize the chart according to your requirements.

To change the chart title, double-click on it and write a relevant title.

You can also choose a preset for your visualization by clicking on the chart, selecting Chart Design and choosing your desired design.

You can play around with customizing your chart with chart tools until you get your desired waterfall or bridge chart.

## When to Use a Waterfall Chart in Excel

Sure, they look pretty, but like everything, there is a time and a place.

There are 5 situation in which the use of a waterfall chart is ideal:

1. Showing Financial Results: It is commonly used to display the components of financial statements, such as revenue, expenses, and net income.

2. Comparing Actual vs. Target Data: The chart can help you compare actual values to target values, revealing gaps and highlighting areas for improvement.

3. Illustrating Profit and Loss Scenarios: It is ideal for visualizing how individual elements contribute to a company’s profit or loss.

4. Presenting Stacked Data: The chart is effective in presenting stacked data in a visually appealing and easy-to-understand manner.

Got your chart look schmick and wan to take your Excel skills to the next level, learn how to count distinct values in Excel by watching the following video:

## Final Thoughts

Waterfall charts in Excel are a powerful way to visualize changes in values over time or between categories.

By following the step-by-step guide in this article, you can create waterfall charts with ease, allowing you to gain deeper insights into your data and communicate your findings more effectively.

But, make sure you prepare your data correctly, select the appropriate chart type, and customize your chart to suit your needs.

With these techniques at your disposal, you can create professional and insightful waterfall charts that will enhance your data analysis and presentations.

Happy Waterfalling! (if that’s even a thing)

In this section, you’ll find some frequently asked questions that you may have when creating a waterfall chart in Excel.

### What is the purpose of a waterfall chart?

The purpose of a waterfall chart is to track the positive and negative changes in a value over time or between categories.

It helps to visualize the cumulative effect of these changes, making it easier to understand the overall trend and the individual contributions of each value. With dynamic waterfall charts, you data remains updated for stakeholders to review at all times, as long as the range is clearly defined.

### How to create a waterfall chart with negative values?

To create waterfall chart with negative values, you can follow these steps:

1. Prepare your data with positive and negative values, including the starting value and the final total.

2. Select your data range, including the starting value, changes, and the final total.

3. From format data series pane, go to the Insert tab on the Excel ribbon and click on the Waterfall Chart icon.

4. Choose the appropriate waterfall chart type from the dropdown menu.

### How to add data labels to a waterfall chart?

To add data labels to a waterfall chart, you can follow these steps:

1. Create a horizontal or vertical waterfall chart using the steps above.

2. Right-click on any column in the chart and select Add Data Labels.

3. You can then customize the data labels by right-clicking on them and selecting Format Data Labels.

### What are the alternatives to a waterfall chart?

Some alternatives Excel charts to a waterfall chart include:

1. Column Chart: A basic column chart can be used to show changes in values over time or between categories.

2. Line Chart: A line chart is useful for displaying trends over time.

3. bar chart: Similar to a column chart, a bar chart is ideal for comparing values between categories.

4. Area Chart: An area chart is effective for visualizing the magnitude of values over time.

## How to Calculate Percentile in Excel: 4 Great Methods

Are you looking to calculate a percentile in Excel? Well, you're in the right place. To calculate a...

## How to Find Relative Frequency in Excel: 4 Quick Methods

Calculating relative frequency is a fundamental concept in statistics, providing valuable insights into...

## How to Interpolate in Excel: User Guide With Examples

In data analysis, interpolation plays a crucial role in estimating values that fall between known data...

## How to a Take Screenshot in Excel: A Guide for Windows & Mac

As a data analyst or a spreadsheet enthusiast, you’re probably familiar with the many ways Excel can...

## How to Add Numbers in Excel: 3 Top Methods Explained

One of the fundamental operations you perform in Excel is adding numbers. Whether you’re managing...

## Excel Showing Formula Instead of Result? 5 Quick Fixes

Have you ever found yourself in a situation where instead of showing the results of your calculations,...

## How to Hard Code in Excel: 5 Easy Methods Explained

Have you ever wanted to input a value into a cell in Excel and make sure that it remains unchanged, no...

## How to Copy a Formula Down in Excel: A Quick Guide

Copying formulas down in Excel is a handy skill that can save you a lot of time and effort! Whether...

## How to Remove Time from Date in Excel: 4 Quick Ways

When you’re dealing with dates and times in Excel, you might find it necessary to separate the time...

## How to Sum a Column in Excel: 5 Ways (Shortcut Included)

One of the best things about Excel is how quickly and easily it can add up all the numbers in a column....

## How to Calculate Skewness in Excel: Formulas Explained

Do you want to calculate the skewness of your data to understand its distribution? Well, you're in the...

## How to Remove Apostrophe in Excel: 4 Quick Ways

Apostrophes have their place in Excel; however, when not needed, they can clutter your data and make it...