Excel Waterfall Chart that Handles Negative Values

0 Flares Filament.io 0 Flares ×

The main problem people come across when working with Waterfall charts in Excel is that they cannot handle negative values. When a negative value is entered it appears below zero destroying your clever Waterfall chart.

Now there are a few utilities on the market that can help you create a Waterfall chart in a snap. But you don’t need these if you know how to work with them.

This tutorial comes from a video I watched of Bill Jelen explaining how to create Waterfall charts. This video can be seen below.

This is the best Waterfall chart tutorial I have seen. I found it easy to follow, very useful, and therefore wanted to share it with you guys.

The image below show the layout of the Waterfall chart data with the formulas shown so that you can see how it all works.

Data for the Waterfall chart

Waterfall chart handling negative values

5 thoughts on “Excel Waterfall Chart that Handles Negative Values

  1. I’m not sure exactly why but this blog is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I’ll check back later on and see if the problem still exists.

  2. Thank you for another informative blog. Where else could I get that kind of information written in such a perfect way? I’ve a project that I am just now working on, and I’ve been on the look out for such information.

  3. It looks to me that this web site doesnt download in a Motorola Droid. Are other folks having the same problem? I like this webpage and dont want to have to skip it whenever Im away from my computer.

  4. Hello there! I could have sworn I’ve been to this blog before but soon after reading via some of the post I realized it’s new to me. Anyhow, I’m surely pleased I identified it and I’ll be book-marking and checking back often!

Leave a Reply

Your email address will not be published. Required fields are marked *