Forum Discussion
Excel doesn't recognize Maps
- 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.
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.
- Maksim TerlyaevJul 25, 2017Copper Contributor
Thanks a lot!!!