Pine BI - Waterfall Charts

Advanced Waterfall Chart (Excel 2013+)

  • ​Select the chart you want to add

  • Select the range with the Actual Results

  • Can be created from normal cells, tables and Pivot Tables

  • Data Range can both horizontal or vertical

  • Template available

  • Available with both Higher the Better (Up) and Lower the Better (Down) options

  • Can have negative totals

  • Every line can be total value. To do that, simply write "Yes" in the Total column. The value cell for the respective row must be empty (see below)

  • The first value can be changed, so that it is not a Total. To do that, write "First" in the column Total. (see below)

  • Works best with Excel 2013 or newer. Older versions will not be able to show the data labels and may prompt and error.

Simple Waterfall Chart (Excel 2013+)

  • ​Select the chart you want to add

  • Select the range with the Actual Results

  • Can be created from normal cells, tables and Pivot Tables

  • Data Range can both horizontal or vertical

  • Template available

  • Available with both Higher the Better (Up) and Lower the Better (Down) options

  • Can have negative totals

  • Every line can be total value. To do that, simply write "Yes" in the Total column. The value cell for the respective row must be empty (see below)

  • Works best with Excel 2013 or newer. Older versions will not be able to show the data labels and may prompt and error.

Waterfall Chart Features

Copyright © 2018 - 2020 PINEXL Ltd.