跳至主要內容
前往資訊主頁
不確定該從哪裡著手嗎?歡迎進行簡短測驗,以便取得個人化建議。
課程 3 共 4 堂
Google Sheets: Visualizing data
Business Reporting
Google Finance: Research company performance
Access Google Finance data in Sheets
Visualizing Data: Flourish templates.
課程
0% 已完成
5 分鐘 以完成

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
恭喜!您已完成 Google Sheets: Visualizing data 是,正在進行中
為你推薦
你對這個課程的評價為何?
你的意見可協助我們持續改進我們的課程!
要離開並失去進度嗎?
如果離開這個頁面,你將失去當前所完成的所有課程進度。確定要繼續並失去已完成的課程進度嗎?