Use Excel to Create a Map Chart
Updated: Oct 4
Map charts have gotten even easier to create with geography data types.
This feature is available with Excel 360 or 2019.
Simply input a list of geographic values, such as country, state, county, city, zip code, and so on, select your list, and go to the Data tab > Data Types > Geography.
Excel will automatically convert your data to a geography data type, and will include properties relevant to that data that you can display in a map chart.
In the following example, we've converted a list of countries to geography data types, then selected the Tax revenue (%) field from the Add Column control to use in our map.
Now it's time to create a map chart, so select any cell within the data range, then go to the Insert tab > Charts > Maps > Filled Map.
If the preview looks good, then press OK. Depending on your data, Excel will insert either a value or category map.
It's that simple!
Tip: If your data is set up as an Excel table, and then you add a country to the list, Excel will automatically update it as a geography data type and update the linked map chart. Similarly, if you remove a country, then Excel will also remove it from the chart.
Want to learn more?
CLICK HERE to receive my Excel Managing & Auditing Data Free! (thru 4/18/2020 only)