• Go Ask Debbie

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)



©2020 by Go Ask Debbie. Proudly created with Wix.com