Excel Map doesn't recognize regions

[Dokat]

Hi,

I have a worksheet with custom regions and corresponding sales data that i'd like to create an Excel Map chart. However Excel Map doesnt recognize my regions. Is there a work around it to Map this chart in excel.

Attached is my sample worksheet file.

Thanks

 

[Hui]

I would try something like adding more detail

eg:

Great lakes, State, Country
California, USA
etc

Notes from the power map website



I don't have access to a suitable version to test those

 

[Hui]

You may also want to have a read here about using Custom Regions
https://blogs.office.com/en-us/2015/05/18/power-map-for-excel-may-update-for-office-365/

 

[Chihiro]

Setting up custom region layer/map can be pain (unless there is open source one that you can find). If it's not necessary to color entire region (like chloropleth map), then just find central geo code (lat/long) for each region and use that to map your chart (such as bubble or bar).

Otherwise, you'd need to use custom region mapping as explained int the link provided by Hui.

Although, there are good use case and many useful visualization using maps. In many cases, charting on map isn't very informative or useful in telling story via data.

Take the example chart found in Hui's link (first video). It's hard to read, 3d bar obscures some data points behind it... and since it's mapped on sphere, by rotating perspective, weight/significance of each bar get distorted.

 

[Dokat]

Hi,
I added corresponding states to the data table and manage to generate a Map.

Thank you