Learn to create linked / automated Waterfall chart with distinct colours for up and down variances
Email questions to: [email protected]

Advanced P%L analysis Course:
Access full course, including presentation, practice files and solved Excel file for P&L analysis: https://ebitda.thinkific.com/pages/start
FP&A playlist: https://www.youtube.com/playlist?list=PLcRqJFBzcNZWuJmu96M_SFbUIHAJ2aLZu
Take the poll: https://www.youtube.com/channel/UC7rg-IpTVtKCFcjOtOMGqag/community

Looking for more personalized help?

Get in touch with me on one of these platforms:
Instagram: https://www.instagram.com/learnaccountingfinance
Facebook: https://www.facebook.com/profile.php?id=100063564513161
Tiktok: https://www.tiktok.com/@learnaccountingfinance
Website: https://www.learnaccountingfinance.com
Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

Learn to create linked / automated Waterfall chart with distinct colours for up and down variances, data labels update automatically, graph colour changes automatically to reflect the positive and negative values, and the chart is updated with changes in the pivot table.

https://www.instagram.com/learnaccountingfinance
https://www.learnaccountingfinance.com

Learn pivot table data crunching business skills here: https://amzn.to/3lgYB5E
Learn all about Excel in one place: https://amzn.to/3laCXQx

Course Alert:
If you would like to learn in detail, how to calculate income statement variances and the impact they have on sales $, profit $ and profit margin % and ebitda %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. https://ebitda.thinkific.com/courses/learn

Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

Zero values are also hidden. This is the best method of creating a Waterfall chart in Excel.

Do not spend too much time trying to figure out how to create waterfall chart in Excel. This video shows you a simple yet highly effective method of creating a waterfall chart in Excel.
You will also learn to use the IF function, formatting of data labels to hide zero values, adjusting the scale of Axis on the chart.

A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. The waterfall chart is also known as a flying bricks chart or Mario chart due to the apparent suspension of columns (bricks) in mid-air. Build a bridge or waterfall chart in Excel

A waterfall chart can be used for analytical purposes, especially for understanding or explaining the gradual transition in the quantitative value of an entity which is subjected to increment or decrement. Make a waterfall chart in Excel

Create a Waterfall chart in Excel with auto updating data labels
Once you learn the trick, its not difficult at all and can be automated for changing set of values in a data table or pivot table.

Hope you enjoy the video. Make sure to give a thumbs up, and share your thoughts in the comments section