Excel waterfall graph

Waterfall graph in Excel and Tableau 

Tuesday, November 9, 2010 10:17:10 AM

Lots of people are fond of creating a waterfall graph, but haven't figured out how to do it.

Here's the method that I've found to be simple and effective.  The basics are to first create four series:

A Base series for setting the beginning and ending balances. (blue)
An 'UP' or positive influence to the balance - (green)
A 'DOWN' or negative influence. -- (red)
A series that sets the bottom of the element in the UP or down.  This series is formatted with the border and area set to 'None'.

That's it.  The tricky part is the calculation to determine the number to use in the bottom series.  For the first element, it is simply the beginning balance less the down amount.  Subsequent columns are the prior bottom plus the prior up amount less the current column down amount.

Because I really like Tableau for graphics, I also used it to create the waterfall chart.  Download the Tableau workbook to understand how that was done.

Download Sample Excel Workbook Download Sample Tableau Workbook
Sample Excel Waterfall Chart:  Sample Tableau Waterfall Chart:
Copyright© Brad Earle

re: Waterfall graph in Excel

Wednesday, November 10, 2010 2:33:06 PM KP

Hey,  thanks so much for posting this.  I really appreciate it. 

re: Waterfall graph in Excel

Thursday, February 23, 2012 1:14:08 AM novo 7

Online Acquisto Levitra Generico Ellbloowl

Wednesday, March 11, 2020 6:47:22 PM StepCig
Grisfulvin V No Prescription Cialis Buy Kamagra India Cialis Forum Cialis Ligne

Liquid Amoxicillin Dosage Ellbloowl

Friday, March 20, 2020 1:05:52 AM StepCig
Acheter Cialis Viagra Generique buy cialis 5mg Cialis 20 Mg Indicazioni Cialis Donde Comprar Levitra

8 + 8 =  
Site Map | Printable View | © 2008 - 2020 KB Earle Associates LLC | |