# Excel Challenge 10

Claudia Buckley

#### Join the Excel conversation on Slack

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

Start working on the Excel challenge with this data workbook.

How good are you at representing data visually?

In this challenge, we’re looking at some numbers that come in from our website analytics software.

Here’s what to do:

• First, watch the challenge video and read the instructions below the video.
• Review the previously published video(s) or article(s) suggested.
• Put yourself to the test!

## The challenge

We need to generate two charts from each worksheet - one which shows the new and returning visits by country, and the other which shows the proportion, or percentage, of paid accounts by country. Your manager didn't tell you what type of charts to create - it’s your job to determine the best chart based on the type of data you will be representing.

You’ve decided that since you will need to do this process every three months, you should just create a macro to do it all in one click each time.

The charts should be on the same page as the data they represent, and they should be formatted with proper labels and titles.

Set up your macro, run it for each quarter and your job is done.

If you need clues or a refresher, watch our videos on how to make a graph and how to create a macro, and you’ll be ready to take on this challenge.

Start working on the Excel challenge with this data workbook.

## The solution

We hope you'll enjoy 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 Basic and Advanced Excel course to help you learn more essential formulas, functions, and practical, real-world Excel skills. Or check out our Excel Macros and VBA course to start automating more of your Excel tasks.

Ready to become a certified Excel ninja?

Take GoSkills' Macros & VBA course today!

#### Join the Excel conversation on Slack

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

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.