Course Content

  • Formulas

Course Content


  • Choose your data.
  • Select Insert > Waterfall or Stock chart > Waterfall from the Insert menu. You may also make a waterfall chart using the All Charts item in Recommended Charts.

The data for the waterfall chart is displayed in the pivot table starting in cell M3. The slicer is linked to this pivot table, as well as slicers for the Item field in the pivot table's Filters section.

Waterfall Charts are used to show how a starting value (such as a beginning monthly balance in a checking account) becomes a final value (such as the account balance at the end of the month) through a sequence of intermediate additions (deposits, transfers in) and subtractions.

A waterfall chart can be used for analysis, particularly to understand or explain the progressive transition in the quantitative value of an object that is subject to increment or decrement. A waterfall or cascade chart is frequently used to demonstrate variations in revenue or profit over time.

You can compare numerous things against multiple criteria using the Radar Chart, commonly known as a spider or star chart. It might be used to compare items in several different areas or to see how temperatures change in numerous locations over the course of a year.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere