Excel Workout 25 - Waterfall Chart!

Welcome to Excel Workout #25!

Difficulty Level:

This week’s challenge is designed to test your knowledge on WATERFALL Chart.


A waterfall chart in Excel is a visual representation of data that illustrates how an initial value is influenced by various positive and negative factors. It shows the cumulative effect of these factors, allowing for a clear understanding of the overall changes in the data. In Excel, a waterfall chart is typically created using a combination of bar and line graphs, with the bars representing the positive and negative values and the lines indicating the cumulative totals. This type of chart is commonly used in financial analysis to visualize the impact of different factors on a starting value.


  • Create a waterfall chart using a provided example.

Reply to this post with your formula code and solution file. Please be sure to blur or hide your formula code.

This workout will be released on Monday June 19, 2023 , and the author’s solution will be posted on Monday June 26, 2023 .

Challenge 25.xlsx (8.4 MB)

Good luck,

Ilgar Zarbaliyev

1 Like

Hi @IlgarZarbaliyev,

Here is my solution for this workout.

File Attached:
Excel Workout Challenge #25 Keith.xlsx (8.4 MB)

thanks for the workout

1 Like

Challenge 25_Quadri.xlsx (8.4 MB)

1 Like

1 Like

Hello @Ilgar,
I am new to this forum and I’m excited to be here. It’s great to see all of the Excel Workouts that you’ve posted and I hope to make positive contributions. Thanks for the good work you are doing!
Here’s my solution to the workout:

1 Like

Challenge 25-Rosi.xlsx (8.4 MB)

1 Like

Thank you for your solution, @ToyinTaiwo

1 Like

Thank you for participating in the Excel Challenge related to Waterfall Chart!
I hope you found this challenge to be a fun and engaging way to improve your Excel skills and learn more about how to work with Waterfall Chart! in Excel.

Here is my solution to Workout #25!


Challenge 25 with Solution.xlsx (8.4 MB)

Once again, thank you for participating in this Excel Challenge, and I look forward to seeing you in future challenges and learning opportunities!

1 Like