Excel Workout 25 - Waterfall Chart!

IlgarZarbaliyev · June 19, 2023, 7:16am

Welcome to Excel Workout #25!

Difficulty Level:

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

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.

Task

Create a waterfall chart using a provided example.

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

Period
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

Keith · June 19, 2023, 10:30pm

Hi @IlgarZarbaliyev,

Here is my solution for this workout.

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

thanks for the workout
Keith

QuadriAtharuOlayinka · June 20, 2023, 11:37am

Challenge 25_Quadri.xlsx (8.4 MB)

mbraun · June 20, 2023, 2:51pm

ToyinTaiwo · June 24, 2023, 7:28pm

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:

Summary

Challenge 25.xlsx (8.4 MB)

anonymous211 · June 24, 2023, 8:04pm

Challenge 25-Rosi.xlsx (8.4 MB)

IlgarZarbaliyev · June 25, 2023, 6:39am

Thank you for your solution, @ToyinTaiwo

IlgarZarbaliyev · June 26, 2023, 2:55pm

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!

Solution

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!