Waterfall chart

Waterfall charts are special types of bar graphs. A typical waterfall diagram shows how an initial value is increased by a series of other values ​​and / or reduced, and thus leads to a final value. In such a diagram, for example, a column represented as cost block is divided into its component costs, where the individual cost columns are worn like a waterfall to the right or left (see Figure 1). Often also referred to curves or columns which are composed of individual values ​​, as a waterfall diagram (see Figure 2).

Creation

OpenOffice.org Calc or MS Excel do not offer Waterfall Diagrams as own chart type. This, although you may also be obtained by suitable partitioning of the associated values ​​table and invisible columns. For MS Excel there are for the commercial plug-in " think-cell chart ".

It's even easier to create with the Chart Type " stock chart " a waterfall diagram. Here, the data table for the chart is constructed so that the closing price of the previous bar is the opening price of the next bar. High and low price are not filled. Advantage is that it is not necessary to work with hidden bar, a change from positive and negative values, the 0 - line is not a problem and the conditional formatting of value-adding and werterniedrigenden influences already preformatted.

Applications

Communications Engineering

In communication engineering the diagram, the perspective view of short-term power spectrum of a signal, from which the change in the spectral composition reveals clearly take over. The curves of a measurement offset are arranged in series or color-coded in the form of a grid graph. It can also be observed statistical distribution of measured values ​​over time to illustrate time changes graphically. The upper right picture shows an example. Including the same values ​​are displayed as 2D sums. The distribution of values ​​is not immediately recognizable. To this can be directly read off the total. The lower diagram shows, for example, that the value of 1.9 is exceeded at any time.

Management consultancy

Another example of a waterfall diagram is the EBITDA Bridge.

• Diagram