Knowledge base KB0078

# How do I total multiple series in parallel in a waterfall chart?

## Solution

To calculate the totals per series in parallel, enter e for the individual total of one series. Then use Excel formulas, like the SUM function, to calculate the individual totals for the other series. This has two advantages:

1. The total column stretches to the baseline automatically. Without the e segment, the chart would not be able to identify the total column, and you would have to drag its connector manually.
2. The total column accurately extends right to the baseline even if there are rounding errors or similar problems in other segments.

## 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.

think-cell uses cookies to improve the functionality, performance and security of this site. Your consent is necessary if you want to use the full functionality of this site. More information on the use of cookies by think-cell, your consent and your privacy rights can be found in our privacy policy.