KB0077: How do I mix positive and negative values in a waterfall chart?

Answer

think-cell does not recommend using segments with positive and negative numbers in the same stack. For example, if you use mixed stacks, the computation of connectors is not evident for the viewer of your presentation.

If you want to use segments with positive and negative numbers in the same stack, you have to manually adjust connectors. When you first enter your data in the waterfall chart, connectors will start at the bottom or top of the inserted stack. For mixed stacks you have to move the connector from its original anchor to the "mixed sum"-anchor in the middle as shown in the picture below.

Total labels, i.e. the labels on top of stacks, always display the total of the absolute values within the stack. If you mix positive and negative segments within the same stack, you probably don't want to use a total label for this stack. The total label would show the extent of the stack, not the sum of its (negative and positive) components.

The current version of think-cell also does not have full support for signed segment labels in waterfall charts. If you need signs for segment labels, type them manually into the labels.

KB0078: Totalling multiple series in parallel in a waterfall chart