Create a shareable map chart with Google Sheets : Europe region of a map chart
VariousWeb-en

Create a shareable map chart with Google Sheets

ybierling , , , , , , , , , , , , , , ,

Want to create a map chart to share, either by putting it online on your website like below, or sharing a picture ? And, on top of that, an interactive map ?

This is very easy with Google Sheets. Start by going on your Drive, and select NEW > Google Sheets

Create a shareable map chart with Google Sheets : Create new spreadsheet in Google Docs
Create new spreadsheet in Google Docs

In the spreadsheet, paste your values

Create a shareable map chart with Google Sheets : Paste data in Google Sheet
Paste data in Google Sheet

Select Insert > Chart…

Create a shareable map chart with Google Sheets : Create a chart in Google Sheets
Create a chart in Google Sheets

Your chart might be setup as a bar chart. To change it to a map chart, select the chart, click on the three dots in the top right corner > Edit chart… and in the Chart editor, in CUSTOMIZE tab, Chart type, select Geo chart

Create a shareable map chart with Google Sheets : Change chart type in Google Sheets
Change chart type in Google Sheets

You can then select how you want your chart to be displayed with the different options.

Create a shareable map chart with Google Sheets : Customize a map chart in Google Sheets
Customize a map chart in Google Sheets

For example, change the world region to be displayed.

Create a shareable map chart with Google Sheets : Select visible world region of a map chart
Select visible world region of a map chart

Result example when selecting Europe

Create a shareable map chart with Google Sheets : Europe region of a map chart
Europe region of a map chart

To publish your chart, click on the three dots, and select Publish chart…

Create a shareable map chart with Google Sheets : Map chart publish option
Map chart publish option

You can also get a static image to share.

Get a link to send it to your contacts, or to share it on social networks

Create a shareable map chart with Google Sheets : Map chart publishing options
Map chart publishing options

A box will ask you to confirm the publication

Create a shareable map chart with Google Sheets : Map chart publishing confirmation box
Map chart publishing confirmation box

And link will be displayed, with quick links to share on common social networks

Create a shareable map chart with Google Sheets : Map chart shareable link and social networks shortcuts
Map chart shareable link and social networks shortcuts

By going in embed, HTML data will be given to share on your website, as seen in the interactive chart above this article

Create a shareable map chart with Google Sheets : Embed interactive map chart HTML code
Embed interactive map chart HTML code

Related articles across the web