Waterfall Chart is one of the best data visualization technique that helps in understanding the cumulative effect of sequentially introduced positive values and / or negative values. This chart or analysis is also known as Bridge Chart. A Waterfall Chart or Bridge Chart can be a great way to visualize adjustments made to an initial value. We can understand it with examples, such as the breakdown of expenses in an income statement leading to a final net income value. The initial and final values are shown as columns with the individual negative and positive adjustments depicted as floating steps.
The connecting lines between the columns make the chart look like a bridge with two or more pillars. When analyzing net profit for a product starting from a sale price, where all the adjustments are negative, the chart often resembles a waterfall or bridge between two data points. In Microsoft Excel, We can perform Waterfall Analysis of Financial Information using stacked columns or bars. Also, for excel version after 2016, Waterfall chart is one of the new built-in chart type.
About Waterfall Chart Excel Template
For the sake of being different and enhanced visualization, this waterfall chart excel template uses error bars instead of (or in addition to) stacked columns or bars. Error bars are useful to create the connecting lines and the stepped values, and they simplify handling negative values (though perhaps not as simple as the technique of using up-down bars). Invisible stacked columns are relevant for positioning and displaying the data labels. But, cool part is that you do not need to know how to create the chart from scratch in order to use this template.
Summary of Features of this Waterfall Chart Excel Template
- This waterfall chart excel allows negative values
- Includes dashed horizontal connecting lines
- Includes data labels formatted to show + and – adjustments
- Define intermediate values by placing an “x” in the Pillars column.
- Add new values by inserting rows and copying formulas down
- This waterfall chart excel uses no macros
Also, This waterfall chart excel contains two separate worksheets for creating either a horizontal or vertical waterfall chart. After creating your chart, you can simply copy and paste it into a PowerPoint presentation or report as a picture.
How to download and use this waterfall chart excel ?
To use this free waterfall chart excel template, you should have Microsoft Office/ Microsoft Excel installed in your system. After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software. Once extracted, you can open the file using Excel and start entering data or customizing the template.