Make waterfall charts in Excel (the EASY way!)

Do you want to learn how to create a beautiful waterfall chart (sometimes called a bridge chart) in Excel? This video tutorial goes step-by-step through the process.

Using the standard waterfall chart template available in Excel 2016 (and later versions) the following techniques are covered:
- creating the initial waterfall
- setting the beginning and end total bars
- reducing visual clutter by removing chart borders, gridlines, connecting lines and redundant axes, formatting the horizontal axis, changing the bar colors
- adding chart titles
- formatting data labels using the number format code.

For older versions of Excel without the waterfall option, manually create the chart by manipulating the underlying data and using invisible stacked or error bars.

Waterfall charts visualize the net change between two values. Instead of just showing a beginning value in one bar and an ending value in a second bar, a waterfall chart dis-aggregates all of the unique components that contributed to that net change, and visualizes them individually.

JUMP TO THE SECTION THAT INTERESTS YOU
00:00 Intro
00:26 Waterfall chart introduction
02:06 Main tutorial - make a waterfall chart in Excel
07:20 Recap and outro

BROWSE RELATED RESOURCES

IMPROVE YOUR DATA VISUALIZATION & STORYTELLING SKILLS

STAY CONNECTED

[samanthawing]

Such a helpful video. Explanation was clear and easy to follow. Thank you!

[johnmcconalogue]

nice, used that in work today, much easier than the previous template I was using, thanks

[magicworldbyjorg]

.a cool video keep up the great content.. Thank you…

[albertlarbi]

Please how did you draw the lines in the x-axis

[HappierAppiah]

Hi would you able to share in more detail how you did the text boxes at the end

[Artoootube]

Can you make a video on stacked waterfall charts excel please?