SOLVED

Excel doesn't recognize Maps

Copper Contributor

Map in Excel doesn't find places for map. 3D-maker does. Ordinary map-maker - doesn't. I need help...

Thanks.

2 Replies
best response confirmed by Maksim Terlyaev (Copper Contributor)
Solution

Hi Maksim,

 

Yes, it's hard to push bing engine to recognize non-US places. Most relaible is to add post codes, usually it works:

 

Maps.JPG

After you select all table and insert Maps drag the data area on the column you'd like to show (only one per graph). Your "X" axis will be post codes, right click on map area, select data, and select post code plus region names for the axis. After that you may hide/add/format/ from ribbon menu legend, chart title and data labels.

 

File is here.

Thanks a lot!!!

1 best response

Accepted Solutions
best response confirmed by Maksim Terlyaev (Copper Contributor)
Solution

Hi Maksim,

 

Yes, it's hard to push bing engine to recognize non-US places. Most relaible is to add post codes, usually it works:

 

Maps.JPG

After you select all table and insert Maps drag the data area on the column you'd like to show (only one per graph). Your "X" axis will be post codes, right click on map area, select data, and select post code plus region names for the axis. After that you may hide/add/format/ from ribbon menu legend, chart title and data labels.

 

File is here.

View solution in original post