Microsoft Excel - Waterfall Charts (Better Storytelling)

Learn how to tell better, more detailed stories using Excel's Waterfall Chart. This makes for a nice alternative to boring Column charts.

File Download Link:

00:26 What is a Waterfall Chart
00:48 File download information
00:58 Setting up the data
01:26 Inserting the Waterfall chart
01:34 Customizing the Waterfall chart
01:41 Defining the Total columns
02:36 Removing unnecessary chart elements
03:11 Resizing Data Labels and Axis Titles
03:19 Setting column widths and connector visibility
03:47 Waterfall with Mid-point Balance
04:59 Zooming in to low-resolution Waterfalls
05:58 Displaying an Axis notification
06:43 Setting colors using built-in options
08:31 Warning about using custom colors
08:47 Conclusion

[JM-mbtf]

Waterfall charts are incredibly underrated - probably because people don´t take the time to learn them properly. Now there is an excellent solution 9:18 minutes long. Excellent explanation as usual. You have an exceptionally good voice for explaining difficult problems and make them understandable. I don´t know how many "aha moments" I have had with BCTI videos. Thank you !!

[kkravch]

Great explanation. I wish I had this kind of summary when I started using waterfall charts. Good hints about the colors. Professor!

[IvanCortinas_ES]

Excellent analysis of the situation. Thanks for sharing this Waterfall.

[Swizzletwice]

Great explanation, well-organized, easy to follow, nice voice.

[adrianhoraciosantanavaldes]

Thanks a lot, I have a question unrelated to this video, how would I create a histogram in excel? At least a general formula for the table. I've tried many times and I've ended in failure and have had to do it sometimes even a bit manual. I know how to create them in r, have an idea how to create them in python, but currently in my organization I have to use excel and it's environment, and I have to use power query for mapping different data. In general it's a nightmare for me. Do you have any idea how it could be done? In any of the cases of ways, but not manual 😅, with a similar variation of steps like in r, where you alter the size of each group. For most of the things I use it for is to find year distribution of car populations. Thanks