Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Thanks for the challenge! Here is my solution:
A bit limited ability to format the chart.
Once I got the columns named appropriately, it was a simple use of a few Multi-Field Formula tools and a filter before creating the appropriate chart similar to the output.
Reposting under my new user ID.