I have been trying to get a good visualization of the cumulative causes of changes to a pension fund’s unfunded liability by cause:
-I have tried a waterfall graph – but it is very difficult to “read”.
-I tried a stacked column chart – but some changes are negative, so this doesn’t work well — the height is plain wrong.
-I adjusted the numbers so that the totals added up correctly, but then the negative contributions are invisible.
A full write-up on the topic here.