• Go Ask Debbie

Use Excel to Create a Map Chart

Updated: Oct 4, 2020

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)


Recent Posts

See All