How to Create an Advanced Waterfall Chart in Excel with Split Bars

How to Create an Advanced Waterfall Chart in Excel with Split Bars

HomeOther ContentHow to Create an Advanced Waterfall Chart in Excel with Split Bars
ChannelPublish DateThumbnail & View CountActions
Channel AvatarPublish Date not found Thumbnail
0 Views
In this video I am going to show you how to create an advanced Excel Waterfall Chart Template with Intermediate Totals and Split Bars.

This visually appealing waterfall chart works great for creating an appealing variance analysis chart. I will cover how to set up the data table for creating the waterfall stacked column chart and how to incorporate split and intermediate bars into the chart. The waterfall chart template works for negative and positive movements and allows for the addition or subtraction of however many buckets you need to display. After watching this video you will be able to answer the question of how to create a waterfall chart with intermediate sub-totals and split bars in excel.

***Timestamps***
0:00 Introduction and Overview
2:00 Creating Data Table and Formulas for Chart
6:30 Inserting Stacked Column Chart for Waterfall Chart Template
10:30 Formatting Split Bars in Waterfall Chart
12:46 Adding Data Labels to Chart to a Waterfall Chart
15:58 Conclusion and Final Thoughts

Completed Template Available For Purchase:
https://www.etsy.com/listing/1270927978/excel-waterfall-chart-template-with

ExcelHelpNow Etsy Shop: https://excelhelpnow.etsy.com
— 25% off Everything in Store with Promo Code: YouTube25

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