Waterfall chart

Last updated
An example of waterfall charts. Here, there are 3 total columns called Main Column1, Middle Column, and End Value. The accumulation of successive two intermediate columns from the first total column (Main Column1) as the initial value results in the 2nd total column (Middle Column), and the rest accumulation results in the last total column (End Value) as the final value. Waterfall-chart.jpg
An example of waterfall charts. Here, there are 3 total columns called Main Column1, Middle Column, and End Value. The accumulation of successive two intermediate columns from the first total column (Main Column1) as the initial value results in the 2nd total column (Middle Column), and the rest accumulation results in the last total column (End Value) as the final value.

A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. These intermediate values can either be time based or category based. The waterfall chart is also known as a flying bricks chart or Mario chart[ dubious discuss ] (after the floating bricks in Nintendo's "Super Mario" games) due to the apparent suspension of columns (bricks) in mid-air. Often in finance, it will be referred to as a bridge.

Contents

Waterfall charts were popularized by the strategic consulting firm McKinsey & Company in its presentations to clients. [1] [2]

Complexity can be added to waterfall charts with multiple total columns and values that cross the axis. Increments and decrements that are sufficiently extreme can cause the cumulative total to fall above and below the axis at various points. Intermediate subtotals, depicted with whole columns, can be added to the graph between floating columns.

Overview

The waterfall is known as a bridge or cascade; the chart portrays how an initial value is affected by a series of intermediate positive or negative values. Also, it is similar to Bar Graph. [3]

Applications

A waterfall chart can be used for analytical purposes, especially for understanding or explaining the gradual transition in the quantitative value of an entity that is subjected to increment or decrement. Often, a waterfall or cascade chart is used to show changes in revenue or profit between two time periods.

Waterfall chart showing profitability analysis Waterfallchart ex2.jpg
Waterfall chart showing profitability analysis

Waterfall charts can be used for various types of quantitative analysis, ranging from inventory analysis to performance analysis. [4]

Waterfall charts are also commonly used in financial analysis to display how a net value is arrived at through gains and losses over time or between actual and budgeted amounts. Changes in cash flows or income statement line items can also be shown via a waterfall chart. Other non-business applications include tracking demographic and legal activity changes over time.

Inventory analysis using waterfall chart Waterfallchart ex3.jpeg
Inventory analysis using waterfall chart

There are several sources for automatic creations of Waterfall Charts (PlusX, Origin, etc.)

Related Research Articles

<span class="mw-page-title-main">Logarithmic scale</span> Measurement scale based on orders of magnitude

A logarithmic scale is a method used to display numerical data that spans a broad range of values, especially when there are significant differences between the magnitudes of the numbers involved.

<span class="mw-page-title-main">Chart</span> Graphical representation of data

A chart is a graphical representation for data visualization, in which "the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart". A chart can represent tabular numeric data, functions or some kinds of quality structure and provides different info.

<span class="mw-page-title-main">Spectrogram</span> Visual representation of the spectrum of frequencies of a signal as it varies with time

A spectrogram is a visual representation of the spectrum of frequencies of a signal as it varies with time. When applied to an audio signal, spectrograms are sometimes called sonographs, voiceprints, or voicegrams. When the data are represented in a 3D plot they may be called waterfall displays.

<span class="mw-page-title-main">Bar chart</span> Type of chart

A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent. The bars can be plotted vertically or horizontally. A vertical bar chart is sometimes called a column chart.

<span class="mw-page-title-main">Scatter plot</span> Plot using the dispersal of scattered dots to show the relationship between variables

A scatter plot, also called a scatterplot, scatter graph, scatter chart, scattergram, or scatter diagram, is a type of plot or mathematical diagram using Cartesian coordinates to display values for typically two variables for a set of data. If the points are coded (color/shape/size), one additional variable can be displayed. The data are displayed as a collection of points, each having the value of one variable determining the position on the horizontal axis and the value of the other variable determining the position on the vertical axis.

Web development is the work involved in developing a website for the Internet or an intranet. Web development can range from developing a simple single static page of plain text to complex web applications, electronic businesses, and social network services. A more comprehensive list of tasks to which Web development commonly refers, may include Web engineering, Web design, Web content development, client liaison, client-side/server-side scripting, Web server and network security configuration, and e-commerce development.

In computer programming, operators are constructs defined within programming languages which behave generally like functions, but which differ syntactically or semantically.

<span class="mw-page-title-main">Data and information visualization</span> Visual representation of data

Data and information visualization is the practice of designing and creating easy-to-communicate and easy-to-understand graphic or visual representations of a large amount of complex quantitative and qualitative data and information with the help of static, dynamic or interactive visual items. Typically based on data and information collected from a certain domain of expertise, these visualizations are intended for a broader audience to help them visually explore and discover, quickly understand, interpret and gain important insights into otherwise difficult-to-identify structures, relationships, correlations, local and global patterns, trends, variations, constancy, clusters, outliers and unusual groupings within data. When intended for the general public to convey a concise version of known, specific information in a clear and engaging manner, it is typically called information graphics.

<span class="mw-page-title-main">Pareto chart</span> Type of chart

A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line. The chart is named for the Pareto principle, which, in turn, derives its name from Vilfredo Pareto, a noted Italian economist.

In statistics, the frequency or absolute frequency of an event is the number of times the observation has occurred/recorded in an experiment or study. These frequencies are often depicted graphically or in tabular form.

<span class="mw-page-title-main">Origin (data analysis software)</span> Scientific data analysis software

Origin is a proprietary computer program for interactive scientific graphing and data analysis. It is produced by OriginLab Corporation, and runs on Microsoft Windows. It has inspired several platform-independent open-source clones and alternatives like LabPlot and SciDAVis.

<span class="mw-page-title-main">Sieve analysis</span> Procedure to assess particle size distribution

A sieve analysis is a practice or procedure used in geology, civil engineering, and chemical engineering to assess the particle size distribution of a granular material by allowing the material to pass through a series of sieves of progressively smaller mesh size and weighing the amount of material that is stopped by each sieve as a fraction of the whole mass.

<span class="mw-page-title-main">Radar chart</span> Type of chart

A radar chart is a graphical method of displaying multivariate data in the form of a two-dimensional chart of three or more quantitative variables represented on axes starting from the same point. The relative position and angle of the axes is typically uninformative, but various heuristics, such as algorithms that plot data as the maximal total area, can be applied to sort the variables (axes) into relative positions that reveal distinct correlations, trade-offs, and a multitude of other comparative measures.

<span class="mw-page-title-main">Plot (graphics)</span> Graphical technique for data sets

A plot is a graphical technique for representing a data set, usually as a graph showing the relationship between two or more variables. The plot can be drawn by hand or by a computer. In the past, sometimes mechanical or electronic plotters were used. Graphs are a visual representation of the relationship between variables, which are very useful for humans who can then quickly derive an understanding which may not have come from lists of values. Given a scale or ruler, graphs can also be used to read off the value of an unknown variable plotted as a function of a known one, but this can also be done with data presented in tabular form. Graphs of functions are used in mathematics, sciences, engineering, technology, finance, and other areas.

<span class="mw-page-title-main">Meteogram</span>

A meteogram, also known as a meteorogram, is a graphical presentation of one or more meteorological variables with respect to time, whether observed or forecast, for a particular location. Where forecast data is used, the meteogram will typically be generated directly from a weather forecasting model based on the longitude, latitude and elevation of the location, but it can also be corrected by a meteorologist. Where a meteogram is used to display historical weather observations, this will typically be for a specific weather station.

<span class="mw-page-title-main">Misleading graph</span> Graph that misrepresents data

In statistics, a misleading graph, also known as a distorted graph, is a graph that misrepresents data, constituting a misuse of statistics and with the result that an incorrect conclusion may be derived from it.

<span class="mw-page-title-main">Classification chart</span>

Classification chart or classification tree is a synopsis of the classification scheme, designed to illustrate the structure of any particular field.

<span class="mw-page-title-main">Cascade chart (NDI interval reliability)</span> Tool to determine the inspection intervals

A cascade chart is tool that can be used in damage tolerance analysis to determine the proper inspection interval, based on reliability analysis, considering all the context uncertainties. The chart is called a "cascade chart" because the scatter of data points and downward curvature resembles a waterfall or cascade. This name was first introduced by Dr. Alberto W Mello in his work "Reliability prediction for structures under cyclic loads and recurring inspections". Materials subject to cyclic loads, as shown in the graph on the right, may form and propagate cracks over time due to fatigue. Therefore, it is essential to determine a reliable inspection interval. There are numerous factors that must be considered to determine this inspection interval. The non-destructive inspection (NDI) technique must have a high probability of detecting a crack in the material. If missed, a crack may lead the structure to a catastrophic failure before the next inspection. On the other hand, the inspection interval cannot be too frequent that the structure's maintenance is no longer profitable.

Looker Studio, formerly Google Data Studio, is an online tool for converting data into customizable, informative reports and dashboards. Looker Studio was announced by Google on March 15, 2016 as part of the enterprise Google Analytics 360 suite, and a free version was made available for individuals and small teams in May 2016.

<span class="mw-page-title-main">Horizon chart</span> Visual representation of data

A horizon chart or horizon graph is a 2-dimensional data visualization displaying a quantitative data over a continuous interval, most commonly a time period. The horizon chart is valuable for enabling readers to identify trends and extreme values within large datasets. Similar to sparklines and ridgeline plot, horizon chart may not be the most suitable visualization for precisely pinpointing specific values. Instead, its strength lies in providing an overview and highlighting patterns and outliers in the data.

References

  1. "How to Create a McKinsey-style waterfall chart". Idea transplant. Archived from the original on 2018-08-17.
  2. Ethan M. Rasiel. The McKinsey Way. McGraw–Hill, 1999.
  3. NetSuite.com (2023-06-09). "9 Data Storytelling Tips for More Effective Presentations". Oracle NetSuite. Retrieved 2023-09-28.
  4. "Waterfall Chart". Think Design. 2020-07-24. Retrieved 2023-09-28.