跳至主要內容
前往資訊主頁
不確定該從哪裡著手嗎?歡迎進行簡短測驗,以便取得個人化建議。
課程 4 共 6 堂
Election visualizations linked to Google Sheets
Elections
Covering politics with Google Trends
Visualizing elections
Google Data GIF Maker
Protect your election coverage
課程
0% 已完成
5 分鐘 以完成

Election visualizations linked to Google Sheets

image17_1.png

Keep your election visualizations live by linking them to Google sheets

image17_1.png

Lesson overview

image17_1_ODVbQmx.png

Keep your election visuals up to date with Google Sheets and Flourish

Flourish makes it even easier for you to keep your election data up to date: Thanks to the Flourish live CSV, you can link to a web-accessible CSV file instead of uploading your file to Flourish manually. 

  1. Visualizing seat changes in the EU parliament
  2. Implementing your URL in Flourish
  3. Customizing your visualization in Flourish


image17_1_ODVbQmx.png

Visualizing seat changes in the EU parliament using sheets and Flourish

Linking a Google sheet to a visualisation unlocks the power of sheets. You can scrape data directly into a visualisation or just update it quickly on the fly. These steps will take you through setting up the link between a Google Sheet and Flourish.


Start with a dataset that you want to visualize. This table shows the distribution of seats in the EU Parliament from 2009 to 2024. Let's say you would like to visualize this data set with Flourish and automatically update it using the Live CSV function.


In order to be able to use the table with the Flourish Live CSV feature, we have to publish it first: Click on “File” in the Sheets menu. Continue with clicking the “Publish to web” tab. A new window should open.


For the visualization of the EU parliament, to be available in Flourish we need to link the Google Sheet to Flourish


In order to use the Live CSV feature in Flourish, the Google Sheet needs to be published as a CSV file. To publish the sheet as a CSV, click on the drop down menu on the right and choose the option “Comma-separated values (.csv)”.


There’s another drop down menu called “Published content & settings”. To keep the data up to date, click on the box “Automatically republish when changes are made”.Click “Publish”.


Copy the link to use it in Flourish later on.

Implementing your URL in Flourish

Link your data sheet to your visualization to update the values automatically


Go to Flourish: Choose a visualization that you would like to create using the Live CSV feature. Open the visualization and click “Data”. You will see a drop down menu on the right.


Click on the drop down tab and choose between “Upload data file”“Upload and merge”and “Import from URL”.To use the Live CSV function, select “Import from URL”.


Paste the Google Sheet URL and click "Import".


Your sheet should be linked to your Flourish visualization now.The data sheet will look greyed out. There will not be an option to edit the values in Flourish.

Customizing your visualization in Flourish

The final step is to customise the appearance of the visualization


To make changes to the visualization, first you have to unlink your Google Sheet from Flourish temporarily. Go to your data sheet in FlourishClick “Unlink and keep current data”The grey overlay should disappear afterwards. You can start editing your visualization now.


First, switch from “data” to “preview”To make sure the correct values are being displayed in the visualization, go to “Select columns to visualise” and pick the columns you would like to be used in the parliament chart.In this case, you need columns B to E to visualize the seats correctly.


The number of seats in the parliament chart can be adjusted in Flourish. In 2009, 764 members were elected The European Parliament. Go to “Parliament Layout”Change the number of seats.


To adjust the colors in the visualization: Switch from “data” to “preview”Open the tab “Colours”Choose a preset design or customize displayed colours


A custom color palette is available too: Click into the field “Custom overrides”Put in a value, separate it with “:” and follow up with a colourExample: S&D: red


To use special color hues, use Hex Colour Codes.


Reconnect the Google Sheet to Flourish after finishing the customization. Go back from “preview” to “data” Click the drop down menu on the right and repeat the import process with your Google Sheet.The visualization will be automatically synchronized with the Google Sheet again.


This is the finished visualization! To update the seats in the European Parliament after the 2024 election, add the numbers in your Google sheet and Flourish will update your visualization. Click here for finished example

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