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

OTR Links 01/18/2017


Posted from Diigo. The rest of my favorite links are here.