Create a Map chart in Excel (2023)

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile More...Less

You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes.

Create a Map chart in Excel (1)

Note:This feature is available on Windows or Mac if you have Office 2019, or if you have aMicrosoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.

Download our examples

You can download a workbook with several map chart examples like the ones in this article.

(Video) Create a Map Chart in Excel

Map charts can display both values and categories, and they each have different ways of displaying color. Values are represented by slight variations of two to three colors. Categories are represented by different colors.

For example, the Countries by Tax Revenue % chart below uses values. The values represent tax revenue in each country with each portrayed using a gradient spectrum of two colors. The color for each region is dictated by where along the spectrum its value falls. By default, the higher the value is, the darker its corresponding color will be.

Create a Map chart in Excel (2)

In the following example, Countries by Category, the categories are displayed using a standard legend to show groups or affiliations. Each country is represented by a different color.

Create a Map chart in Excel (3)

Create a Map chart with Data Types

  1. Map charts have gotten even easier with geography data types. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then 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.

    Create a Map chart in Excel (4)

  2. 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.

    (Video) 🌍 How to make interactive Excel Map charts

    Create a Map chart in Excel (5)

  3. If the preview looks good, then press OK. Depending on your data, Excel will insert either a value or category map.

    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.

Formatting your Map chart

Once your map chart has been created you can easily adjust its design. Just click on the map, then choose from the Chart Design or Format tabs in the ribbon. You can also double-click the chart to launch the Format Object Task Pane, which will appear on the right-hand side of the Excel window. This will also expose the map chart specific Series options (see below).


  • There are several map chart specific Series options, however they are not supported in Android devices or Excel Mobile. If you need some of the map Series options, then you can build your chart in Excel for Windows or Mac and view it on an Android device or Excel Mobile.

  • Create a Map chart in Excel (6)

  • Learn more about Formatting Map Charts.

  • Map projections - Change the map's projection style. By default, Excel will display the most efficient style.

  • Map area - Change the map's Zoom level, ranging from a state/province view, all the way to the world view.

    (Video) How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)

  • Map labels - Show geographic names for your countries/regions. Chose to show names based on fit, or show all labels.

Frequently Asked Questions

Question: When I use certain text-based locations, I end up with a blank map and an error, or some of my points map in other countries.

Create a Map chart in Excel (7)

Answer: If you use data where there might be more than one similar location in the world, map charts can’t necessarily tell the difference without more guidance. If possible, add a higher-level detail column to your data. For example, the following locations won’t necessarily map the way you expect since there are many places in the world where these are valid county names:

Create a Map chart in Excel (8)

But the data should map correctly if you add another column for higher-level detail, in this case, Province – This is called Disambiguation:

Create a Map chart in Excel (9)

Create a Map chart in Excel (10)

When there are multiple levels of geographic details, you must separate each level into its own cell/column. For example, “Washington, United States” (State, Country) will not successfully generate a map. In this instance, the data will map successfully when placing “Washington” and “United States” into separate columns.

Create a Map chart in Excel (11)
Data that won't map(State and Country are combined)

Create a Map chart in Excel (12)
Data that will create a map of Washington State


  • Map charts can only plot high-level geographic details, so latitude/longitude, and street address mapping isn’t supported. Map charts also support one-dimensional display only, but if you need multi-dimensional detail you can use Excel’s 3D Map feature.

  • Creating new maps, or appending data to existing maps requires an online connection (to connect to the Bing Map service).

  • Existing maps can be viewed without an online connection.

    (Video) How to Make a Map Chart in Excel - Tutorial 🗺️ 📊

  • There is a known issue where Map Charts which make use of Geography Data Types can sometimes map incorrectly. Please try to include Admin Fields, such as Province or Country when attempting to plot these until the problem is fixed.

Need more help?

You can always ask an expert in the Excel Tech Communityor get support in the Answers community.

Need more help?

Expand your skills


Get new features first


(Video) Create a Map Chart in Microsoft Excel


1. Create a Map chart in Excel 2016 by Chris Menard
(Chris Menard)
2. Create Microsoft Excel Pivot Charts and Map Charts!
(Simon Sez IT)
3. How to create map chart in excel
4. How to Create a Map Chart in Excel With Slicers
5. Create a Map Chart in Excel
(Excel Insights)
6. Excel 2016 - Create a Map Chart
(Mike Thomas)
Top Articles
Latest Posts
Article information

Author: Manual Maggio

Last Updated: 28/05/2023

Views: 6401

Rating: 4.9 / 5 (49 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Manual Maggio

Birthday: 1998-01-20

Address: 359 Kelvin Stream, Lake Eldonview, MT 33517-1242

Phone: +577037762465

Job: Product Hospitality Supervisor

Hobby: Gardening, Web surfing, Video gaming, Amateur radio, Flag Football, Reading, Table tennis

Introduction: My name is Manual Maggio, I am a thankful, tender, adventurous, delightful, fantastic, proud, graceful person who loves writing and wants to share my knowledge and understanding with you.