Skip to main content
Go to dashboard
Not sure where to start? Take a short quiz to get personalised recommendations.
Lesson 3 of 4
Google Sheets: Visualizing data
Business Reporting
Google Finance: Research company performance
Access Google Finance data in Sheets
Visualizing Data: Flourish templates.
Course
0% completed
5 minutes to complete

Google Sheets: Visualizing data

VisualizingData_overview_iskVm5I.jpg

Learn to build visualizations that help you interpret the data and tell data-driven stories.

VisualizingData_overview_iskVm5I.jpg

Lesson overview

VisualizingData_overview_02DLAOd.jpg

Learn to build a data visualization in Google Sheets.


In the previous lesson, Google Sheets: Cleaning data, we learned how to clean the table we imported from Wikipedia using importHTML. Now, we will use Google Sheets to produce visualizations that show readers what the data means.

  1. Creating  a horizontal bar chart.
  2. Adding a title to your chart. 
  3. Resizing a chart.
  4. Creating highlights. 
  5. Improving legibility.
  6. Publishing  your interactive data visualization.

For more Data Journalism lessons, visit:

newsinitiative.withgoogle.com/training/course/data-journalism


VisualizingData_overview_02DLAOd.jpg

Creating a horizontal bar chart.

Bar charts are very useful for numerical comparisons. Our first visualization will be a bar chart showing which movies made more money and how far the highest grossing movies are from the lowest ones.


Select C1, hold shift and select D51, highlighting the two columns we will use for the chart. Click  Insert  > Chart.


In the Chart editor, select Chart type > Bar chart.

Adding a title to your chart.

Now that you’ve made a basic chart, let’s enhance it and make it more readable. 


First, let’s change the title. In the Chart editor, select Customize > Chart & axis titles. Change the title to “Highest-grossing Movies in the World."


Set Title font to Arial and Font size to 24. Make it bold.

Resizing a chart.

To make the chart legible, we need to resize it.


Click on the chart. Drag the bounding boxes, especially horizontally.


Click anywhere on top of the movie titles and hover the mouse around the vertical edges until bounding boxes fade in. Drag the box until there’s enough space for the longest title to be read in full.


Notice that there are 50 bars in the chart, but not 50 film titles. That’s because Google Sheets automatically distributes the names in the list, omitting some of them, to improve legibility. Hover the cursor on top of any bar and a tooltip box will appear showing the name and value of that bar.

Creating highlights.

Let’s make highlights in the chart to draw attention to specific elements for our users.


Change the color of all the bars to gray. In the Chart editor, select Customize > Series and select a dark gray shade for Worldwide Gross.


Let’s highlight the movie Jurassic Park, the oldest movie in the list (1993). Go to Format data point and click Add. Select Worldwide gross: Jurassic Park and click OK. Choose the color red.


Let’s do the same thing to highlight all five Harry Potter movies in blue.

Improving legibility.

We can further improve the design of our chart by adding gridlines.


In the Chart editor, select Customize > Gridlines. In the Horizontal axis, increase the Major gridline count  to 6 and Minor gridline count to 1.


Go back to Customize > Horizontal axis. In Scale factor, select 1,000,000,000. In Number format, select Custom. For Prefix, type $. For Suffix, type “ bn” without quotes, and including the leading space.

Publishing your interactive data visualization.

When you are satisfied with the accuracy, legibility and design of your chart, it’s time to publish it.


Hover your mouse in the top left corner of the chart and click on the three-dotted icon. Select Publish chart > Publish.


You should now have an embed code that you can use on your publication. Any changes will be automatically republished when made.

Congratulations!

InteractiveData_overview.jpg

You completed “Google Sheets: Visualizing data.”



To continue building your digital journalism skills and work toward Google News Initiative certification, go to our Training Center website and take another lesson:



For more Data Journalism lessons, visit:

newsinitiative.withgoogle.com/training/course/data-journalism


InteractiveData_overview.jpg
Congratulations! You've just finished Google Sheets: Visualizing data in progress
Recommended for you
How would you rate this lesson?
Your feedback will help us to continuously improve our lessons!
Save results and track your progress
By leaving this page you will lose all progress on your current lesson. Are you sure you want to continue and lose your progress?