EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Waterfall Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Waterfall Chart

By Madhuri ThakurMadhuri Thakur

Waterfall Chart in Excel

Waterfall Chart in Excel(Table of Contents)

  • Waterfall Chart in Excel
  • How to Create a Waterfall Chart in Excel?

Waterfall Chart in Excel

Waterfall Chart in excel is quite a different but very useful tool used to show the up and down in the data where each tower or column starts from the top of the lowest point of previous data. For example, if a first iteration counts as 100 and the second as 110, then the second column will start after the previous column end at 100, and it will be shown by +10 figure or with number how much the next iteration goes up.

The waterfall chart helps to explain the cumulative effect of how the growth or reduction happening over a period of time. Let’s see an example of a waterfall chart to understand better.

How to Create Waterfall Chart in Excel?

Waterfall Chart in Excel is very simple and easy to create. Let us understand the working of the Waterfall Chart in Excel by some examples.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)
You can download this Waterfall Chart Excel Template here – Waterfall Chart Excel Template

Example #1

Let’s take the example that “XYZ” company wants to know how the sales accumulating month by month from the initiation of business for one year and want to analyze how sales fluctuate each month.

The below table shows the sales generated each month for a particular year.

Waterfall Chart Example 1

Now we need to add accumulated sales to current month sales to know the current month accumulation. For example, 15000(Jan)+16500(Feb)=31500 is the total sales by the end of February; similarly, you can add the 31500(Sales up to Feb)+17000(March sales)=48500 is the total sales by the end of March.

Performing accumulation in Excel

First, copy the Jan sales in the first cell of accumulation as shown below.

Waterfall Chart Example 1-1

Later insert the formula for the addition of January sales to February sales in the accumulation row under the February column, as shown in the below screenshot.

Waterfall Chart Example 1-2

The Formula gives the result as:

Waterfall Chart Example 1-3

Now copy the formula to all other months as shown in the below screenshot so that we will get the accumulated sales of each month.

Waterfall Chart Example 1-4

Creating the chart

Now select the entire data range go to insert >charts >column >under column chart > select Stacked column as shown in the below screenshot.

Waterfall Chart Example 1-5

You will get the chart as below.

Waterfall Chart Example 1-6

Now we need to convert this stack chart to a waterfall chart with the below steps.

Select the chart or bars and right-click; you will get the pop-up menu; from that menu, select the “Select data” option.

Waterfall Chart Example 1-7

When you click the “Select Data”, one menu will pop up as below. Click on “Accumulation” and then click on “up arrow” as marked with red color.

Waterfall Chart Example 1-8

Then the chart will convert as below. The blue color appears on the up, and orange appears at the bottom.

Waterfall Chart Example 1-9

Now select the orange bars and do a right-click; click on the “fill” option available, select “No fill”. So that orange bars will change to white color (colorless).

Waterfall Chart Example 1-10

Now the chart will look like the below picture.

Waterfall Chart Example 1-11

Select the total bar alone and fill some color as your wish, then it looks like below.

Waterfall Example 1-12

If you observe the chart, it looks like water falling from up to down or “flying bricks” that is the reason it is called a waterfall or flying bricks chart.

If you want to see each month’s sales in the chart, you can add the values to the bricks. Select the blue bricks and right-click and select the option ”Add Data Labels”.

Waterfall Example 1-13

Then you will get the values on the bricks; for better visibility, change the brick color to light blue.

Waterfall Example 1-14

Double click on the “chart title” and change to the waterfall chart.

Waterfall Example 1-15

If you observe, we can see both monthly sales and accumulated sales in the singles chart. The values in each brick represent the monthly sales, and the position of the brick with respective values in the left axis represents the accumulated sales.

Waterfall Example 1-16

Example #2

Let’s take the example of fluctuation of the share price of “ABC Ltd” for a week.

Waterfall Example 2

Column “Start price/End price” represents the starting and ending price of the share for the week. 500 is the beginning price, and 545 is the ending price.

The column “Price” represents the share price by the end of the day (If the share price increases, the change will add to the last date price and vice versa). Column “UP” represents the growth in share price. The column “DOWN” represents the fall of the share price. The column” Fluctuation” represents the amount of increase or decrease of the share price on a particular day.

Now select the data excluding the last column, “Fluctuation”, and create a chart as described in the previous process; then, the chart will look like the below chart.

Waterfall Example 2-1

You can consider the green color bar as “Base”; hence, you can make the color as “No fill” then, you will get the waterfall chart with a combination of colors.

Waterfall Example 2-2

As described previously, add the values to the chart.

Waterfall Example 2-3

If you want to decrease or increase the gap between two bars or want to perform any other changes as per your project requirements, then you can do that by selecting the bars, and right click then selects “format data series”.

Waterfall Example 2-4

You will get the menu on the right side, change the gap width as per your requirements.

Waterfall Example 2-5

You can also select the pattern in the background by selecting “Format Plot Area”.

Waterfall Example 2-6

Under Format Plot Area, go to fill and Select “Pattern fill” and Select the first pattern as shown in the below screenshot.

Waterfall Example 2-7

Then your chart will look like the below screenshot.

Waterfall Example 2-8

We can also change the thickness of gridlines by selecting the gridlines option, as shown below.

Waterfall Example 2-9

By clicking on Format Gridlines, a pop-up menu will appear under that; go to “Line Color” and Select “Solid Line” and also select the fill color as shown in the below screenshot.

Waterfall Example 2-10

You can observe the thickness of lines has changed from the previous screenshot to the current screenshot.

Waterfall Example 2-11

Like this, you can do a little makeover to look your waterfall chart more attractive.

Pros of Waterfall Chart in Excel

  • It is easy to create with little knowledge in excel.
  • One can view the monthly and accumulated results in a single chart.
  • The chart will help to visualize both negative and positive values.

Cons of Waterfall Chart in Excel

  • When we send to users who have Excel versions apart from 2016, they may not be able to view the chart.

Things to Remember

  • Gather the required data without errors.
  • Apply formulas to get the accumulated balance in any one column as it should have accumulated a balance.
  • One column should have start and end values.
  • Select the data and apply a stacked bar chart.
  • Apply “No Color” to the base.
  • Add required formats as you wish to look chart better

Recommended Articles

This has been a guide to a waterfall chart in Excel. Here we discuss its uses and how to create Waterfall Chart in Excel with excel examples and downloadable excel templates. You may also look at these useful functions in excel –

  1. Pie Chart In MS Excel
  2. Pivot Chart in Excel
  3. Interactive Chart in Excel
  4. Surface Charts in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Waterfall Chart Excel Template

EDUCBA

Download Waterfall Chart Excel Template

EDUCBA

डाउनलोड Waterfall Chart Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more