Microsoft Excel

2 minute read

Excel Challenge 22

Claudia Buckley

Claudia Buckley

Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

What technique would you use to display a cell range that changes relative to the last value entered in the source data? Join our latest Excel Challenge and test it out!

Download your challenge data!

Start working on the Excel challenge with this data worksheet

To get started,

  1. Watch the challenge video. 
  2. Download the Excel worksheet. 
  3. Complete the challenge task.
  4. Share your solution, discuss, or ask for help in our Slack channel.

The Challenge

Here’s the scenario: 

We want our graph only to show sales for the three most recent months. Can you create a dynamic chart range so that when a new month is added, the chart updates itself by reporting on the last three months in the data set? Notice that the chart title also changes automatically.

Do you have a favorite method for handling this scenario? You might be able to pick up some clues on creating this type of dynamic behavior from our Excel resource library, or from the following YouTube video.

Tell us what method you would use before I share my solution next week.

Download your challenge data!

Start working on the Excel challenge with this data worksheet

We hope you'll enjoy working on this challenge!


The Solution

 

We hope you enjoyed taking part in this challenge!


It's Your Turn

Do you have an Excel brainbuster you came across recently? How did you solve it? Join our Slack channel and share it with me! Maybe we'll feature it (and you 😉) on an upcoming monthly GoSkills Excel challenge!

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


If you enjoyed this challenge, you’ll love our Basic and Advanced Excel course which will help you learn more essential formulas, functions, and practical, real-world Excel skills. 

Level up your Excel skills

Become a certified Excel ninja with GoSkills bite-sized courses

Start free trial

Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

Claudia Buckley

Claudia Buckley

Claudia is a project manager and business skills instructor at GoSkills. In her spare time, she reads mystery novels and does genealogy research.