KB0078: How do I total multiple series in parallel in a waterfall chart

Explanation

In think-cell's waterfall chart, the e segment automatically stretches between the values to which its ends are connected. If only one end of the e segment is connected to a specific value, it automatically stretches to the baseline, typically calculating the total of the waterfall.

You can have stacks (columns) consisting of multiple series in the waterfall chart. However, you can only have a single e segment per stack. If you use multiple e within a single stack, then all segments except one will collapse, and the remaining segment will stretch the entire extent. To calculate multiple totals in parallel, simply use Excel formulas to calculate the totals for all segments except one (which can continue to be calculated by means of the e).

When using Excel formulas within the total column of a waterfall chart, make sure you enter the negative sum of the desired values, because from the chart's perspective, the total column goes downwards (towards the baseline). It is recommended to continue using the e for one of the segments to make sure that the column accurately hits the baseline, even if there are rounding errors or other problems in the other segments.

See also

KB0077: Mixing positive and negative values in a waterfall chart