(From https://academy.datawrapper.de/article/236-how-to-create-a-live-updating-symbol-map-or-choropleth-map) Datawrapper makes it easy to create live-updating charts, but creating live-updating choropleth and symbol maps is not supported yet. Here’s how to achieve it anyway.

Create a symbol/choropleth map

To do so, go to https://app.datawrapper.de/create/map and click on Choropleth map or Symbol map. Then, choose the regions you’d like to put your data in. Click Next

Go to step 1 of the chart editor

You will arrive in step 2: Add your data. Now you can either change the URL direcctly to app.datawrapper.de/chart/YOUR-ID/upload or follow the rest of the instructions here: 

Find the link  Looking for the other data table? at the bottom and click on it.

Notice how the URL changed from app.datawrapper.de/map/YOUR-ID/data to app.datawrapper.de/chart/YOUR-ID/describe. You’re not in the Datawrapper map editor anymore but in the second step of the chart editor.

The option to insert a link to an live-updating CSV or Google Sheets is in step 1 of the chart editor. To get there, we’ll need to change the URL:

Change the last part of the URL from “describe” to “upload”, so that it looks like this now: app.datawrapper.de/chart/YOUR-ID/ upload 

Insert a link to your data 

You should see the question How do you want to upload your data?. Click on Link external dataset, where you can now insert your link as described in our Academy article “Automatic chart updates: How to publish charts with external data sources”.

We will choose a Google Spreadsheet of coronavirus cases for our symbol map. In this workaround to create live-updating maps, Datawrapper won’t be able to adjust the data for you or warn you about it, so the data needs to be in a perfect format from the beginning. 

For symbol maps, you’ll need the columns “Lat” (or “latitude”), “Long” (or “longitude”) and the columns with your data as needed. The coordinates need to be in the decimal format (like “29.3829”), not in a DMS format (like “29° 22′ 58.44” N”). 

????  For choropleth maps, you’ll need a column with the ID’s (e.g. the regional names) and at least one column with your numbers. The ID’s need to be exactly as phrased by Datawrapper in step 2: Add your data. 

If unsure or the map looks weird, build a normal choropleth/symbol map with Datawrapper first, then download the data with “Get your data” to learn about the Datawrapper spelling of IDs and column headers. This is how the Google Sheets looks like for the symbol map: 
Get a shareable link of your Google Spreadsheet and paste it below Enter URL to an external CSV file: 

Go back to the map editor and style your map

Now you’ll need to change the URL again to get back to the map editor. To do, change two things, “chart” to “map” and “upload” to “visualize”. So instead of app.datawrapper.de/ chart/YOUR-ID/upload, your URL now looks like app.datawrapper.de/map/YOUR-ID/visualize. Hit Enter.

This brings you in step 3: Visualize of the map editor, where you can style your map. Select the size of your symbols, choose the right color gradient for your Choropleth map, etc. The map uses the sizes and colors you defined and will continue doing so regardless of new values in your dataset. Meaning, the colors in your choropleth map don’t adjust to new min-max values. If you know that your future data will have greater or smaller values than it currently has, consider changing the min and max values of your color gradient right now, or remember to change the colors later on. 


Publish your map

Now click on step 4: Publish and publish your map. 

And that’s it! Your map will check your dataset every minute and pull new changes that your readers can see when they refresh the page where you embedded your map.

Leave a Reply