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: www.storytellingwithdata.com/...
● Excel tutorials playlist | • Excel tutorials
● How to turn data into stories: a mini workshop | kzread.infoHfx1X9WSGYQ
IMPROVE YOUR DATA VISUALIZATION & STORYTELLING SKILLS
📚 Order Cole’s new book! storytellingwithyou.com
📚 Read the books: www.storytellingwithdata.com/...
🖥 Follow the blog: storytellingwithdata.com/blog
📊 Practice in the SWD community: community.storytellingwithdata...
🎧 Listen to the podcast: storytellingwithdata.com/podcast
🍎 Attend a workshop: storytellingwithdata.com/works...
STAY CONNECTED
👉 LinkedIn: / storytelling-with-data...
👉 Twitter: / storywithdata
👉 Instagram: / storywithdata
💡 Don’t forget to subscribe for new videos! kzread.info...