Skip to content

GS Challenge 12 – Data Visualization

Welcome to Google Sheets Challenge number twelve!

In this article, you have four questions to test your data visualization skills within Google Sheets. In other words, I’ll see how good you are working with charts and graphs.

You can click the link below to download the spreadsheet and test yourself before reading through the article. In fact, I highly recommend it!

Google Sheets Challenge 12 – File Download

Good luck, and give it your best effort!

Question 1

For question one, your goal is to create a chart to display the change in monthly revenue over the course of one year.

Question 1 – Solution

Question one requires you to depict the change in numerical values over time. A line chart is often the best tool for showing change over time.

To create a line chart, select all of the data. Then go to Insert Chart.

Google Sheets will try to guess which chart you want.

If Google Sheets did not create a line chart, look to the panel on the right and change the chart type to Line chart.

Finally, double-click on the title and change it to something like “Yearly Revenue.” You now have a line chart showing the change in revenue over the year.

Question 2

For question two, your task is to create a chart to compare the sales performance of the four regions.

Question 2 – Solution

To solve question four, I recommend creating a bar chart to compare the four metrics.

Now you might be wondering – “Why a bar chart and not a pie chart? These are percentage metrics, after all!”

Believe it or not, a pie chart is not the best solution when it comes to displaying the comparison of percentages. In fact, you can read all about this idea in my article, “Too Much Pie.” I also highly recommend checking out the newsletter listed below, written by data visualization expert Stephen Few.

Save the Pies for Dessert

Anyway, back to the task at hand. To create a bar chart, select the data and go to Insert > Chart.

Google Sheets will probably create a pie chart. Change the chart type to Bar chart using the panel on the right.

You now have a chart comparing the sales performance across regions.

Question 3

For question three, your task is to create a chart showing the distribution of units sold. You also want to display the distribution in groups of 10.

Question 3 – Solution

A histogram is the best chart to show the distribution of values in a dataset.

To create a histogram, select all of the data. Then go to Insert Chart.

In the panel on the right, change the chart type to Histogram chart.

Next, click on Customize, and under Histogram, change the bucket size to 10.

Finally, double-click on the title and change it to “Distribution of Units Sold.” You now have a chart showing the distribution of units sold.

Question 4

For question four, you must create a chart to depict the correlation between study hours and average exam scores. You must also add a trendline.

Question 4 – Solution

When you want to show the correlation between two values, it is best to use a scatter plot.

So to create a scatter plot, select all of the data. Then go to Insert Chart.

In the panel on the right, change the chart type to Scatter chart.

To add a trendline, select Customize. And under Series, check the box next to Trendline.

You now have a chart showing the correlation between the two metrics.

How Did You Do?

So how did you do? Did you find working with charts and graphs to be easy or hard? What was the hardest part?

Leave me a comment and let me know how you did. I’d love to get your feedback!

Also, if you missed the first few Google Sheets Challenges, you can find them below.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top