Waterfall Charts are one of the many new Charts available only in Excel 2016.

They are very popular in the current corporate environment as they graphically show the positive and negative movements within your Monthly Net Profit or Cash Flow.

When I was working at General Electric, I had to create these charts on a monthly basis using formulas….outch!

Waterfall Charts are very useful in that they show how the initial value e.g. January Income, is affected by a series of positive and negative expenses.

In this example I show you how easy it is to insert a Waterfall Chart using Excel 2016.

NB: If you do not have Excel 2016 installed, there are a couple of great Excel add-ins that allow you to insert these charts in Excel 2013 and prior:

The Waterfall Chart Creator by TheSpreadsheetGuru

Peltier Tech Charts for Excel by Jon Peltier

 

DOWNLOAD EXCEL WORKBOOK

STEP 1: Enter the values in your workbook with the Starting Total e.g. January Income.

Then add the positive and negative values, like direct & indirect expenses.

Finally enter the Ending Total e.g. February Income, which will Sum all of the above values.

data sum

 

STEP 2: Highlight all the data and go to Insert > Recommended Charts

highlighted data

insert chart

 

STEP 3: Select All Charts > Waterfall > OK

waterfall

 

STEP 4: Double Click on the Starting Totals column (e.g. January Income) and this will bring up the Format Data Point dialogue box.

“Check” the Set as Total box

format data point 1

NB: This will set this column’s value so it starts on the horizontal axis at zero and will not “float”

 

STEP 5: Now select the Ending Total with your mouse and once again, “Check” the Set as Total box

format data point 2

 

Now you have your beautiful looking Waterfall chart and you can quickly point out to your management where the variances have occurred…

final waterfall

WATERFALL CHART

 

HELPFUL RESOURCE:

Microsoft+Excel+Waterfall+Chart+Creator+Template

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can! To create an Excel Table you need to highlight your data and press CTRL+T See Tutorial Here Once you have your Excel Table you can add your Excel Sparklines inside one Column and us...
Clustered Bar Chart: Year over Year Comparison If you want to compare products or businesses Year over Year and have category names which are way too long, then the Clustered Bar chart is the one for you. In the example below the category names relate to companies and I am comparing their sales for 2013 and 2014. DO...
Clustered Bar Chart: Year to Date Sales If you want to compare your Year to Date sales and have category names (eg. products, business names, channel partners, sales reps etc)  which are way too long, then the Clustered Bar chart is the one for you. In the example below the category names relate to companies and I a...
Sparklines: Column Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell.  A Column Sparkline is best used when you have lots of data points. You can style them in different colors and add a marker for the High and Low points of your data.  As your da...