Insert a Map Chart in Excel 2016

You can easily create a map chart in Excel 2016. The map chart uses Bing data for countries, regions, postal codes, and states. Simply select your data, click on the Insert tab, click Maps and a map will appear. You can change the color of the map and add or delete data and the map will refresh. This new feature came out in November 2016.

Steps to insert a Map chart in Excel 2016

  1. Select any cell within the data range.
  2. Click Insert > Charts > Recommended Charts, or Insert > Charts > Maps, then select the map chart.
  3. Once you press OK, Excel will insert your map.

Map Chart in Excel 2016

The map chart uses Bing data for the following:

  1. Countries
  2. Regions
  3. States
  4. Postal Codes

Map charts available with Excel 2016:

  1. Mercator
  2. Miller
  3. Robinson

Chris Menard’s YouTube video on creating a Map Chart

Additional resource: https://support.office.com/en-us/article/Create-a-Map-Chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b?ui=en-US&rs=en-US&ad=US

 

Pin It on Pinterest