A method to compare budget versus actuals using a waterfall chart in Excel.
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- online-excel-training.auditex...
🇿🇦- Our main website- www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Variance analysis (actuals versus budget)
00:49 Create a waterfall bridge chart explaining the variances
01:40 Waterfall chart using stock charts in Excel (pre Excel 2016)
02:06 Move labels below the waterfall chart
02:19 Make up movements green, down red in Waterfall chart