Embedded Files
European Migration in 2021
European Migration in 2021
Click on this icon to see the legend
Click on map symbol to see data for a country
How To Make The European Migration 2021 Map
How To Make The European Migration 2021 Map
1. Get Cleaned Data On Your Google Drive
1. Get Cleaned Data On Your Google Drive
Create a new Google Sheets document in your Google Drive
Copy 'Cleaned Data' over to your empty Google Sheet
Give it a name and make sure the document is "shared"
Make a percent total column
In cell b25 do - "sum=(b2:b24)"
Name new Row "Percent of Total"
in cell c2 do - "=B2/$B$25" and then copy it to the entire "C" row
Add title, "European Migration 2021"
Under description add information where the data came from and a URL:
3. Set Default View
3. Set Default View
First, zoom in on map so that Europe is bigger than what is shown on the screen.
Click on 3 dots to the right of the map title to bring down the menu.
Click "set default view"
4. Change Layer Name
4. Change Layer Name
Click on untitled layer and change the name.
A map title and a layer name should never be duplicated.
Title shows location and date
Legend (layer) explains the data
5. Import Data to the Layer
5. Import Data to the Layer
Copy "clean data" from above to a google sheet and put in your Google Drive.
Click "import" under layer.
Find your cleaned data on Google Drive.
5. Position and Title Data
5. Position and Title Data
Left choose country.
Right choose country.
6. Your Map Should Look Like This
6. Your Map Should Look Like This
7. Delete Data Total Row Used to Make the Percent of Total Column
7. Delete Data Total Row Used to Make the Percent of Total Column
(Left) Open Data Table.
(Right) Right click on column one and choose "delete row."
8. Style the Layer Data
8. Style the Layer Data
Click uniform style and change to "style by data column" and choose "Percent Total".
Pick a color ramp and 4-6 categories (no more the 6).
"no labels" unless you choose a basemap without labels.
Note, I changed colors in the color ramp because there was no difference in some of the colors.
9. Pick a Base Map
9. Pick a Base Map
Try a base map that is NOT the default (everyone has seen the default).
BUT, make sure your "thematic layer" stand out ON TOP of the base map.
10. Embed your Map in Google Sites
10. Embed your Map in Google Sites
View "published" site to see how the "default view" looks.
Adjust "default view" in Google MyMaps.
German Migration Maps & Data
German Migration Maps & Data
Download data and create a new map and follow same instructions as above.
If you use more than one MyMap in the same Google Site, consider using the same base map and symbology to make the theme of the website look the same.
Add Rhineland Palatinate KMZ as separate layer and give it a style.
Experiment with 'normalizing data by area' instead of just raw count. When possible, normalizing data leads to better comparisons.
Germany & Rhineland Palatinate KMZs
Germany & Rhineland Palatinate KMZs
10 layer limit in MyMaps.
5mb limit per KML (KMZ are compressed KML so even smaller).
Page updated
Google Sites
Report abuse