Waterfall Chart

A Waterfall Chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. The waterfall chart is also known as a flying bricks chart or Mario chart due to the apparent suspension of columns (bricks) in mid-air. The Waterfall Chart is used to show how an initial value is increased and decreased by a series of intermediate values, leading to a final value.

Best Situations to Use Waterflow chart:

To show incremental changes in the values over time

Default Chart Image:

Properties of the Waterfall Chart:

  • Axis Setup: The user can either set up the base as zero or else set up another minimum value. The user can include horizontal Marker lines as well as Vertical marker lines and change their color.

  • Background: The user can get the reflection of the chart by enabling the shadow option can also change the color and increase & decrease the transparency of the shadow. The user can also change the background color, adjust its transparency as well as enable a border and change its color.

  • Export Options: The user can enable the ‘Enable Context Menu’ to download the reports in various formats by clicking on the chart from the preview section. The user can change the heading and subheading of the downloaded chart, and the name of the downloaded file from this section.

  • Formatter: The user can change units to % or none. The user can set the Precision option to see value in decimal format. The user can display currency value in INR, Pound, USD. The position of the currency symbol can be set as Prefix (if the currency is in INR format) otherwise, it can appear on the right-side as Suffix. Number Formatter can set it in Indian or International.

  • General: The user can change the height, width, top, and left values. If initial visibility is not enabled, then the chart will not be available for the first preview. If the Max Button is enabled, then the user can maximize the chart. The user can change the base type between Plain, Gradient 1, Gradient 2, and Gradient 3. The user can set colors for positive, negative, and Total Values. It is also possible to adjust the bar size.

  • Legend: The user can enable the internal legend to show and change the font size, font color, font style, etc.

  • Subtitle: The user can enable the subtitle there is any second title. The user can change the name, font color, font size, font style, etc.

  • Title: The user can change Title Name, Font color, font size, font style, etc.

  • Tooltip: Here If the user wants to show the description of the series can use the tooltip by enabling it.

  • X-Axis: The user can show the x-axis line, change the x-axis line color, label color, font size, font weight, font family, description, etc. The user can rotate the label using the X-Axis.

  • Y-Axis: The user can show the y-axis line, change the y-axis line color, label color, font size, font weight, font family, description, etc.

General Properties:

Axis Setup Properties:

Background Properties:

X-Axis Properties:

Title Properties:

Y-Axis Properties:

Dataset Property Pallet

Data Used

The following data was used to generate the given example:

Year
Expense
Revenue

2008

85

80

2009

100

95

2010

120

135

2011

140

180

2012

140

180

2013

140

180

2014

140

180

2015

140

180

Select the Year column as Category field and Expense or Revenue column as Series field to plot the data as displayed below.

Please Note: The Waterfall chart supports only one series field.

Waterfall charts after changing its properties

Base Type with Plain

Base Type with Gradient 1

Base Type with Gradient 2

Base Type with Gradient 3

Last updated