Easiest Excel Waterfall Chart (Bridge graph) from Scratch - Works with minus values

Oct 18, 2016 #MsExcel
For the complete course with different variations of the waterfall chart click here: https://courses.xelplus.com/p/excel-waterfall-chart-courseShow more

Read the full post here and download the workbook: https://www.xelplus.com/easiest-waterfall-chart-in-excel-from-scratch/

Excel Waterfall Chart from Scratch - This video shows you an easy and flexible method to create the waterfall chart in ANY Excel version.

Details:
In this specific lecture I will give you an overview of the three important techniques used to generate this chart.

The reason I call this the most flexible waterfall chart is because you have control over a lot of features that you don’t have control over if you use the new Excel 2016 waterfall chart. For example, you can change the color of the delta bars to whichever color you like, independent of the color scheme. – You can decide where you want to have the data labels, you can include new data series to add your own customization. It also has no problem to show values that go below the horizontal axis, i.e. if you have negative cumulative values.
The data preparation table is also quite simple. This technique does not use the general stacked column chart with invisible base approach, instead it uses error bars and up/down bars to get a very flexible, yet simple waterfall graph.

If you’re interested to learn more about the different ways you can use error bars, up/down bars, how to fully control your data labels or even your series labels - and other tricks and techniques in charts, I recommend you take a look at my online excel visualization/chart course.

★ My Online Excel Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel