How to create infographic with a map using Google Spreadsheets

Here you can see a quick and very easy way of creating infographic with different data in Google Spreadsheets.
First take some data. I have salaries in different countries in French.

LocationSalaires
Allemagne16.5
Andorre10
Autriche12
Belgique14.5
Danemark29.5
Espagne9.5
Finlande14.5
France17
Islande15.5
Italie15
Liechtenstein23.5
Luxembourg25.5
Monaco13.5
Norvège20
Royaume-Uni25
Russie13.75
Saint-Marin13
Suède16
Suisse28
Vatican11.5

Now I will make a filter for my columns to be able to sort my data.

The next step is to filter my data based on “Salaires”. I will make from minimum to maximum.

After this we will apply conditional formatting with colours. This will allow us to see visually the difference in salaries.

Now you will see an option window on your right, set up the following conditions.

After this you have to receive a nice table with colourful data.


Now if you would like to embed your data firstly you have to publish your document.

In “Entire Document” drop-doown you can choose would you like to publish certain tab or the whole document.

And now copy-past the embedment code to your website. If you want to manipulate the height or width of your embedment, don’t forget to add :
height=”815″
width=”500″
in <iframe …

How to create an interactive geo map with colour condition formatting using Google Spreadsheets

Now insert an a chart.

In a chart type section choose “Map –> Geo chart”.

Make the following set up to match the colours of your table.

Publish and embed your map.

Map embedment for your website.

If you want a picture of your map. Unfortunately a standard way of downloading image does not work. So, instead just make a print screen and upload an image to your website.

Would you like more help with Geo infographic, drop me a message. I know many ways. For example, map customisation with Adobe Illustrator, map customisation with geo plugins.

Leave a Reply

Your email address will not be published. Required fields are marked *