Adding a waterfall chart is performed similar to other empower® charts, however its data entry differs slightly. In an Excel® table a x is entered into the column that is to correspond to the sum of data of the previous data (in previous columns). To indicate a column sum, the value of one or more series has to be set to x for this column. If only one series value is set to x, the overall sum (over all series) is calculated.
Two or more series values set to x indicate that the per series sums are calculated and displayed. If any row of a column contains the keyword "<new>", a new waterfall starts with the upcoming column. Sum columns are calculated separately for each new waterfall.
In addition, it is also possible to change the direction of your waterfall chart. This way waterfall charts can also be set up in reverse. To change the direction of your chart, simply click in the Data button in the action bar and select Left to right or Right to left. For laying waterfalls, you can choose between Bottom to top or Top to bottom.
You can also display multiple waterfalls after one another. To add a new waterfall within a chart, click Data in the Action Bar and select Edit Data. In the corresponding cell of the Excel® table enter the keyword “<new>”. The new waterfall chart will then begin at the next column while the sum starts at zero.