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
● SWD chart guide: https://www.storytellingwithdata.com/chart-guide
● Excel tutorials playlist | https://www.youtube.com/playlist?list=PLwEff2aXpeWuz9fJrQLxmr5pnyoaESIka
● How to turn data into stories: a mini workshop | https://youtube.com/live/Hfx1X9WSGYQ

IMPROVE YOUR DATA VISUALIZATION & STORYTELLING SKILLS

WORKSHOPS and 8-WEEK COURSE – Use YOUTUBE10 for 10% off!
Attend a workshop: http://storytellingwithdata.com/workshops.
Become an SWD scholar: https://www.storytellingwithdata.com/public-workshops#course

ADDITIONAL RESOURCES
Read the books: https://www.storytellingwithdata.com/books
Enroll in our on-demand course: https://www.storytellingwithdata.com/good-to-great-course
Follow the blog: http://storytellingwithdata.com/blog
Practice in the SWD community: http://community.storytellingwithdata.com
Listen to the podcast: http://storytellingwithdata.com/podcast

STAY CONNECTED
LinkedIn: http://linkedin.com/company/storytelling-with-data-llc
X/Twitter: http://twitter.com/storywithdata
Instagram: http://instagram.com/storywithdata
TikTok: https://www.tiktok.com/@storywithdata
Don’t forget to subscribe for new videos! http://youtube.com/c/storytellingwithdata?sub_confirmation=1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.