Why do I get a warning when building my Waterfall chart?
Written by Julien Villemonteix | Updated
Aside from the simple warnings about an incorrect selection (empty cells, non continuous range...), there are two warnings that require some additional explanation.
Warning: "Data used to create a bridge might be inconsistent! The last value does not watch the others."
To draw a bridge, the first and last values need to be results, not effects. This means you need to ensure that the last value and each intermediate value are the sum of the previous intermediate value and the following effects.
If you build your effects and intermediate values using formulas, you should not encounter this issue.
Note that UpSlide leaves some small margin for error to avoid getting this warning simply due to rounding issues.
Warning: "Several representations are consistent with the data. If the result does not match what you expect, please apply a bold font to intermediary results."
In some very rare occurrences, you might input data that forms two distinct representations (see example below). You can force one of these representations by applying a bold font on all of the result values.