How to make an AWESOME Waterfall Chart in Excel (with 2 adv. tricks)

Zebra BI for Office is the latest addition to the Actionable Reporting toolkit for data professionals and enthusiasts who want to take their reports to the next level. With the combination of two powerful add-ins, Tables and Charts, Zebra BI gives you an immediate understanding of your business performance.

~

Do you want to create WATERFALL charts in Excel? They are great for showing income statements, balance sheets and changes from one point in time to another. We can use the "waterfall chart" in Excel to create such a thing. In this video learn how to make a waterfall chart and a betterfall chart.

⏱ In the video:
=============
0:00 - The two variations of Waterfall chart
0:57 - Inserting and adjusting the "waterfall chart" in Excel
2:45 - The "problems" with Waterfall chart in Excel
3:46 - Introducing "Betterfall" chart
4:39 - Using the Zebra BI Waterfall Chart in Excel
7:41 - Tweaking the "waterfall chart" labels with custom formatting

📁 Download the Sample Workbook:
==============================

Please download the sample file and practice the concepts. It has sample income statement data and both graphs.

📈📊 More on Charting & Data Visualization with Excel:
=============================================

One of my specialities is building AWESOME 🤩 charts with Excel & Power BI. In my channel & website you can find 400+ examples of beautiful and insightful charts for any kind of reporting. Please watch these other videos to learn some useful skills for work.

~

CONNECT WITH ME 🔗

~

#waterfallchart #datavisualization

You know what is my favourite live stream?
It's the Niagara Falls 😂

[Supersquishyawesomeness]

I worked at McDonald’s in the 90’s and when we needed a computer upgrades they’d send out a tech from Panasonic to do it but a manager would have to stay overnight with them. While we we’re waiting on stuff to finish on the one system he would teach me excel on the other. He seemed happy to teach someone who was willing to learn. I think that’s why I subscribed to you.

[Amarnadhable]

Thanks Chandoo.. How did i miss your videos so far on such important topics?

[alistairspence]

Excellent ... never too old to learn new tricks!

[arunkumarr]

Hi Chandoo Anna, Awesome tutorial as Love from Andhra 😊

[sirgangram]

You always brings some new info to all . Thanks so much !

[chrism]

This was really great, thanks Chandoo!

[arbazahmad]

Thanks Chandoo 😊 for Zebra bi tutorial...

[excelangola]

Hi Chandoo, hope you are Good. Can you please talk one day about how data processing freelancer works?
Thanks one more time for sharing your knowledge. 😉

[geekatari]

Can I have you guys show some appreciation to Chandoo by joining me with a thumbs up 👍🏻! He is an amazing guy!

[avishekd]

U r superb. It's better than the Excel guru, s add in YouTube. Thanks a lot Chandoo sir 🙂.

[ashutoshdas]

Teacher please help. @Chandoo Sir

Which course help to grow in WFM or MIS job?

[-seesi-]

Hello Chandoo,

first of all: I am a part of your Excel School Community and youre courses are glorious, thank you very much for all your knowledge sharing.

When you are creating this stunning charts or dashboards, how do you decide which techniques to use?
I want to start my own Excel Business and have the fear that I create files for my costumers that won't work because I use features they don't have in their excel version.

Do you have a list of the features each excel version introduced?
Remembering all the features and when they got implemented feels overwhelming.

For example: The new array functions in 365 (like FILTER, SORT).
It's awesome to use them, but most people are not using 365 right now.

Hope you understand what I mean.

Greetings! 🙋🏻‍♂

[mkd.]

Could you please upload a video on cumulate distribution chart, usually known as S Curve in project management

[ranaganguli]

I am working jn 0365.. unable to find the waterfall icon

[sivakrishna]

Hi can anyone please tell how to recover files in excel

[praveen]

I have a different question. My data values are showing in 1B, 1M, 1k etc. How can I convert to normal number. Values are in text.

[taizoondean]

Thank You Sir, Please upload DAX videos on Power BI🙏

[eswar]

Sir I have been watching your videos .iam working as a teacher.iam 40 years old, if I get any technical skills can I do any it job at this age.if yes can you suggest which is suitable for me.i have MA Economics.pliz give me your suggestion

[xandrew_._]

Hyyy brotherrr please i hav order data in power bi please help me to clean and visualize please i didnt go to my test to nd tommorow is last day to submit

[faizalahmed]

Chandoo...you look tensed..feels like something bad is going on in your life...
I certainly hope everything is fine..but if not...i pray that you overcome any Hurdles and difficulties and stay happy..