Forum Discussion

Maksim Terlyaev's avatar
Maksim Terlyaev
Copper Contributor
Jul 23, 2017
Solved

Excel doesn't recognize Maps

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

Thanks.

excel
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 24, 2017

    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:

     

    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.

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 24, 2017

    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:

     

    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.

Resources