Ana içeriğe atla
Kontrol paneline gidin
Nereden başlayacağınızdan emin değil misiniz? Kişiselleştirilmiş öneriler almak için kısa bir test yapın.
Ders 7 / 17
Google Sheets: Visualizing data
Veri Haberciliği
Permissions: Source Google Data.
Dataset Search Quickstart Guide
Public Data Explorer: Access a world of data.
Google Trends: Understanding the data.
Google Data GIF Maker
Visualizing Data: Flourish templates.
Data Source: Global Forest Watch.
Google Sheets: Scraping data from the internet
Google Sheets: Cleaning data
Data Studio: Make interactive data visualizations
Visualizing Data: Introduction to Tilegrams.
Visualizing Data: Advanced Tilegrams.
Google Trends: Improving your search results.
Data Source: Election Databot.
check_box_outline_blank Veri Haberciliği: Take the Quiz
0% tamamlandı
5 dakika tamamlamak için

Google Sheets: Visualizing data


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


Lesson overview


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:


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.



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:

Tebrikler! Dersi tamamladınız Google Sheets: Visualizing data Evet, devam ediyor
Sizin için önerilenler
Bu dersi nasıl değerlendirirsiniz?
Geri bildiriminiz, derslerimizi iyileştirmemize yardımcı olacaktır.
Sayfadan çıkıp ilerlemenizi kaybetmek istiyor musunuz?
Bu sayfadan çıkarsanız mevcut dersteki ilerlemeniz kaydedilmez. Devam etmek ve ilerlemenizi kaybetmek istediğinizden emin misiniz?