Excel – Creating a floating (waterfall) chart

PROBLEM: Charting data with a starting and ending point.  This method of charting is sometimes referred to as floating and is often used to create waterfall charts.

SOLUTION: Quickly create a floating chart.

Excel 2010 & 2013 – Creating a floating (waterfall) chart

 

The first step is to enter the data into a worksheet.  Record the minimum and maximum values for each series.  Insert a row between the minimum and maximum values and write a formula to calculate the difference between the two values.

Select the first three rows of the data table and then create a stacked 2-D column chart with no legend.  Change the format of the bottom data series to No Fill.  The chart will now display the data as floating columns, depicting the highest and lowest values for the series.

If you found this post helpful please ‘Like’ us!

Facebook
Facebook
Twitter
Google+
Google+
http://excelatwork.co.nz/2014/03/26/look-mumno-legs