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:
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