Follow

Excel: Create a Stacked Waterfall chart

A Waterfall chart is an intuitive tool to visualize the cumulative effect of sequentially introduced positive or negative values. With the stacked waterfall, you can also decompose the effects under different columns :

Excel does not offer this feature by default. With UpSlide you can create those charts.

To create this chart, simply select your data, click on the Charts button of UpSlide. A Dropdown menu should appear, select Stacked Waterfall Chart :

waterfall4.png

It should automatically create the chart, according with Corporate Branding colors :

waterfall5.png 

The first and last line are always treated as results (not effects). If your data contains one or more intermediary result as in the image above, UpSlide will automatically detect it and use the appropriate column to represent it.

Note that you cannot decompose an effect into values or a different sign. Excel would not know how to display it.

If this case occurs, simply decompose the effect in two with the positive value on one side and the negative values on the other.

Try it Yourself !

On the Chart menu, click on Examples to insert a Worksheet with sample data in order to create those charts :

waterfall3.png     waterfall7.png

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk