My post about

how to create a McKinsey-style waterfall chart

is one of the most read on this blog. The method I showed breaks down when there are many negative numbers involved. The solution is a manual one, sketch your waterfall on a piece of paper, fill in all the numbers, and fiddle with colours until you get it right. Remove the automated data labels and put text boxes with the values instead. See the example below.

If you liked this post, why not subscribe to daily updates about presentation design via email? Just blog posts, no spam, or you can follow Jan on Twitter to never miss a thing.