Excel Map Charts .... a little help needed

So I just got the latest update to Excel 2016 and now have access to Map Charts

This is not the same as 3D maps (which are very cool, see video below). Show this to the next person who tells you that Google sheets is as good as Excel...!

So back to map charts...

First question: How on earth do I use them? Come on Microsoft, give a little guidance! So after doing a bit of searching in the Excel help menu I found a short video which looked great but was largely unhelpful

My findings so far

Start with a 2 column table with unique values.

Then get a little more adventurous by using a 3 column table

The Table headings are important ! Zip Code works, Post Code does not

Also it appears that if you have a few values you will get unique entries in the legend but for bigger data sets it will give you a heat map type scale.

Let me know if you come across a good guide on to how to set these up, e.g. what column names are the best to use.

**Update******

Found this which is more useful..

https://support.office.com/en-us/article/create-a-map-chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b#bkmk_faq

**************

Thanks

Wyn

My Other Articles

www.accessanalytic.com.au