, We are looking here at a vertical or so called calculation Waterfall Chart. The status bars represent base and result measures (e.g. sales and EBIT) whereas the contribution bars in between represent the increase or decrease of the measures. Preparing data and inserting waterfall charts. In order to create waterfall charts for contribution analysis, you must add an additional column to your source data table. The column marks "fixed" data categories and optionally also the values with negative meaning, such as discounts, costs, etc. 