Create A Waterfall Chart In Excel - The Excel Hub
We cover how to create a waterfall chart using the built in functionality in Excel. A waterfall chart shows how an initial value is affected by a series of values and how this in turn affects the final value. In our example, we have a company’s forecast profit which we can compare with the actual figures. We have the actual income and actual loss which in turns feeds into the actual profit. It’s worth noting that here actual income means the quantity by which income exceeded the forecast income and loss is the amount by which actual loss differed from forecast loss. Actual profit is therefore simply forecast profit + actual income + actual loss.
Excel Charts Playlist:
• Excel Charts - The Excel Hub
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Create A Waterfall Chart In Excel - T...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Create Waterfall Chart: (1:52)
Make Chart Meaningful: (2:40)