Excel: Waterfall chart - this is how it is displayed

If you want to visualize the contents of your table, you can choose between various charts in Excel. These include, for example, the waterfall chart. In this, the running total is displayed, adding or subtracting values. The individual columns are also color-coded to distinguish them.

How to create a waterfall chart in Excel

If you want to display the data of your Excel spreadsheet in a chart, you can choose between various types. With the help of a waterfall chart, it is also possible to display the running total and show the influence of certain values on it.

1. First, select the data in your worksheet from which you want to create a waterfall chart. Select them for this purpose.
2. Then click on the "Insert" tab at the top of the bar.
3. Here you will now see a "waterfall chart" icon. Select this one. Then click on "Waterfall".
4. Now a waterfall diagram is automatically created from the selected data. To edit this further, click on "Diagram design" at the top and then on "Format.". Alternatively, you can click anywhere on the chart and select the appropriate options.
5. On a Windows PC, after "Insert", click the "Insert Waterfall or Price Chart" option and then click the "Waterfall" button. Alternatively, you can also go to "All Charts" and then select "Waterfall" in "Recommended Charts".