Interactive Maps

Over the weekend, I ran into this story

How to make awesome interactive map using Google Sheets in under 1 minute?

Of course, I had to share it with my friends.  It was interesting to see it being favourited and shared.

And, of course (2), I had to try it myself.  Here’s my result as an image.  I was really impressed with the stats popping up as you would mouse over various countries.

map

Did it take more than the minute promised?  Probably; I’m a slow reader.

It was fun and would have been the sort of activity that would have been done at a computer contact meeting.  There’s a lot there like finding and copying data, moving to a spreadsheet, copying it and then using the magic Google pixie dust to turn the data into the map.

I was ready to bookmark and move on when I got a message.  “Hey, Doug, we’re an Office 365 board and can’t use Google.  Will it work with Office 365?”

I didn’t know the answer right off but it seems like it should be possible.  I don’t have an Office 365 account so I can’t be sure on that platform but I do have my regular Microsoft account.  I decided to give it a shot and go pure Microsoft.  That meant using Windows and the Edge browser.

I didn’t get far before I ran into challenges.

The first challenge came after I selected the data from the Wikipedia article.  It copied all right but wouldn’t paste into Excel Online properly.  Instead of honouring the various cells, everything from that country pasted into the same cell.  This would take a lot of fixing to get right.  I tried a few times to see if it was something that I was doing wrong.  No dice.  Then, I opened a new sheet in Google Sheets and it pasted properly.  I copied again and pasted back into Excel and it went well.  So spreadsheet to spreadsheet was OK.

The second challenge came when I wanted to draw the map.  The selection of charts in Excel Online didn’t include an appropriate map.  There was this…

book-6-xlsx-microsoft-excel-online

It wasn’t the same.  I poked around and looked for some add-ins that might do the trick but I couldn’t find something that looked like it would do the trick.

I’m now well over a minute.

I turned to OneNote.  Bringing the data in generated an error that only 100 items could be pasted.  I went with a smaller set of data but couldn’t find a way to generate the map.

So, for this example, it looks like there was only one choice.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s