Excel Challenge 22: Create a Dynamic Excel Chart Range

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

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.

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.