Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria

Are you ready to practice your data analysis skills using formulas and charts? If so, then this month’s challenge is for you!

Everything you need to participate in the challenge can be found below. To take part:

• First, watch the challenge video and read the instructions below the video.
• Review the previously published video(s) and article(s) on which the challenge is based.
• Download the Excel worksheet you will use to complete the challenge tasks.
• Put yourself to the test!

Want to discuss, ask for help, or share your solution? Join our Slack channel to share your insights and questions with other learners and experts.

The challenge

Here’s the scenario to be solved from the download file:

We have been sent a dataset that shows the total sales generated by managers in different regions: North, South, East, and West. 

Our manager would like to see a breakdown of managers by region where the sales are greater than or equal to this month's target of $1600. 

We need to show the results in a table and also in a simple column chart. 

Some points to note:

• Everything needs to be dynamic so that if new managers are added, the formulas update correctly. 
• The chart title should be dynamic and change when a new region is selected. 
• There are no rules when it comes to formatting the chart - go wild!
• This challenge uses functions that are available in the following versions of Excel: Excel 365, Excel 2021 and Excel 2019.

Would you like to test your knowledge further? Try sorting the results in the table from largest to smallest by sales value. 

How quickly can you complete this challenge? Fifteen minutes? Ten? Less?

Hints😉

If you’re just getting started with Excel, all the knowledge you need to solve this challenge has been shown in the following resources: 

	The Ultimate Guide to Excel Charts
	Using the FILTER function With Multiple Criteria

If you’re already proficient with Excel, this should be quite easy. Maybe you can tell us a creative way to solve this problem in our Slack channel.

Have fun!

The solution🎉

We hope you enjoyed taking part in this challenge!

Stay tuned to the GoSkills Excel resource hub for more Excel challenges, and check out our range of expert-led Excel courses for all skill levels to further sharpen your skills.

If you enjoyed this challenge, try the Excel for Business Analysts course to help you make sense of large datasets.