Excel Map Chart Not Working? Fix the Common Causes

If an Excel map chart is blank, missing, or showing the wrong places, first check that your chart has recognizable geographic names and numeric values, then confirm Excel can access its online mapping service. In Microsoft 365 for Windows, select a simple location-and-value table and choose Insert > Maps > Filled Map; the sections below explain what to check when that does not work.

What an Excel map chart needs

A Filled Map chart colors geographic regions according to values in your worksheet. For example, a table with a Country column and a Sales column can show sales by country, while a State column and an Orders column can color states. Excel identifies the locations and matches them to regions on a map; it is not plotting individual street addresses or drawing a custom map.

Start with one row per region and clear column headings. A reliable basic layout is:

Location: a country, state, province, county, or other supported region.
Value: a numeric measure such as revenue, population, or number of orders.

Keep the geographic level consistent where possible. A list mixing countries, cities, and postal codes can be difficult to interpret, even if Excel recognizes some of the entries. If you need a hierarchy, put levels in separate columns—for example, Country and State—and use complete names so Excel has enough context to identify each region.

Check that the chart type is available

In Excel for Microsoft 365 on Windows, look for Insert > Maps > Filled Map. If Maps is absent or unavailable, confirm that you are using a supported, up-to-date desktop version of Excel and that the workbook is open in the desktop app rather than another spreadsheet program. Map-chart availability and the ribbon layout can vary by Excel version, platform, and organizational settings. Install available Office updates and ask your administrator whether online connected experiences are restricted.

Do not confuse a Filled Map with 3D Maps. A Filled Map colors boundaries such as countries or states. 3D Maps is a separate feature for plotting geographic or time-based information on a globe or map. If your goal is to show individual points using latitude and longitude, a Filled Map is the wrong chart type.

On Mac, the ribbon and chart controls may look different from the Windows instructions. Use a current Excel version that supports map charts and look under the Insert tab for the map-chart option. In Excel for the web, available chart creation and editing options can differ from desktop Excel; if you cannot insert or change the chart there, open the workbook in the desktop app.

Clean up location names and the table layout

Location recognition is one of the most common causes of a map that appears incomplete or incorrect. Short names may refer to more than one place: “Georgia” could mean a U.S. state or a country, and “Springfield” could refer to many cities. Add a country or state column to distinguish ambiguous names, and prefer full names over abbreviations when you can.

Check the worksheet for structural issues before inserting the chart:

Use one header row, with a clear label for each column.
Remove blank rows or columns within the data range, and avoid merged cells in the source table.
Make sure every location is in its own cell rather than combining several places in one cell.
Check that the value column contains numbers, not numbers stored as text, labels, or formatted strings such as “about 500.”
Review blanks and errors. A missing value cannot provide a meaningful measure for that region.

For example, use “United States” in a Country column and “Georgia” in a State column rather than relying on a bare “Georgia” entry. If Excel still fails to identify a name, try the Geography data type from Data > Data Types > Geography. A recognized geography can help validate or clarify a place, although converting cells does not guarantee that every location is supported in a Filled Map.

Fix a blank map or missing regions

A chart may appear blank while Excel is resolving locations, or because it cannot match the entries to map regions. First wait briefly, especially in a large workbook, then check whether the chart changes. Verify that the computer is online and that Excel is allowed to use connected online services. Map charts rely on online mapping capabilities, so an offline session, network restriction, privacy setting, or organization policy can prevent the map from loading or resolving locations.

If only some areas are missing, inspect those location entries individually. Correct spelling, add the country or parent region, and remove extra punctuation or inconsistent abbreviations. Then check the chart’s source range: select the chart and use Chart Design > Select Data to confirm that the intended rows and columns are included. If new rows were added after creating the chart, expand the source range or make the data an Excel table before rebuilding the chart.

It can also help to recreate the chart from a small test range. Copy a few clear locations and numeric values to an empty area, select those cells, and choose Insert > Maps > Filled Map. If the small example works, the issue is likely in the original data range or its location names. If it does not, investigate Excel version, connectivity, privacy settings, and service availability rather than repeatedly changing the same data.

Correct a map that colors the wrong places

When Excel recognizes a name but maps it to the wrong country or region, provide more geographic context. Add separate Country, State, or Province columns where appropriate and make the names explicit. A city name alone is often not enough to identify the intended place. Avoid assuming that a postal code will be unique across countries; include its country when the data spans borders.

Also check that your values describe the same unit and period. A map can be technically correct but misleading if one row is annual revenue and another is monthly revenue, or if one value is a total and another is a rate. If multiple rows refer to the same region, decide whether to combine them into one total or use a different chart design. A map chart is clearest when each region has one comparable value.

To inspect how Excel interprets the chart, select a region and use the Format Data Series pane to review the available map-area and series-formatting options. The options presented depend on the chart and data. Changing the map area can affect how much of the world is visible, but it cannot resolve a misspelled or ambiguous location; fix the source data first.

Check chart formatting and data values

A map may be working even when it looks empty or indistinct. If nearly every region has a similar value, the color differences may be subtle. If one value is far larger than the rest, it can dominate the scale and make smaller differences hard to see. Review the underlying numbers, then use the Format Data Series pane to adjust the color scale or map-area presentation where those controls are available.

For an easier-to-read result, use a sensible title, keep the measure and unit clear, and avoid adding more detail than the map can show. A map of orders by state is useful for spotting geographic patterns; it is not always the best way to compare exact values. Add a table or a bar chart when readers need precise rankings, and verify that the chart’s legend or color scale makes higher and lower values understandable.

If labels are missing, remember that map charts do not necessarily label every region automatically. Look in the chart elements and formatting controls for available data-label options. Labels can overlap or clutter a dense map, so a legend plus a supporting table may communicate the values more clearly.

Know when a different chart is better

Filled Maps are designed for regions with geographic boundaries. They are not a general-purpose plotting tool for addresses, delivery stops, store locations, or GPS coordinates. For a point-based view, consider 3D Maps if it fits your data and version of Excel, or use a mapping application designed for location pins and route analysis. A scatter chart can display numeric X and Y coordinates, but it does not provide the familiar geographic context of a road map.

There are other cases where a standard chart is more suitable. Use a bar chart when the main task is comparing a short list of places precisely. Use a Filled Map when spatial patterns matter—for example, identifying which states have unusually high service demand. Excel map charts use built-in geographic boundaries; they do not let you draw custom territories or redefine county borders inside the chart.

A practical troubleshooting order

Work through these checks from the quickest to the more involved:

Confirm you have selected Insert > Maps > Filled Map, not 3D Maps.
Reduce the source to one location column and one numeric value column, with headers.
Replace ambiguous names with full geographic names and add country or state context.
Check for text-formatted numbers, blanks, errors, and omitted rows in the source range.
Confirm internet access and check whether Excel’s connected experiences are restricted by privacy settings or an administrator.
Update Excel, reopen the workbook in desktop Excel if needed, and test a small sample table.

Save a copy before making major changes to the source data. If a small, unambiguous test chart also fails on a supported, current Excel installation with online access, record your Excel version and the exact behavior, then contact your organization’s IT support or Microsoft support. That information helps distinguish a data problem from a device, account, or service issue.

Frequently Asked Questions

Why is the Map chart option greyed out in Excel?
Check that you are using an Excel version and platform that support map charts, and that you are working in Excel rather than a different spreadsheet app. Updates, connected-experience settings, and organization policies can also affect availability.

Does an Excel map chart need internet access?
Map charts rely on online mapping capabilities to identify and display geographic information. If the chart will not load or resolve locations, check the internet connection and whether privacy or administrator settings restrict connected services.

Why does Excel map my location to the wrong place?
The location name may be ambiguous. Add a country, state, or other parent region in a separate column, and use full names where possible. A city name by itself may not identify the intended location.

Can an Excel Filled Map show addresses or latitude and longitude?
It is intended to color geographic regions, not plot individual addresses or coordinate-based points. For point locations, use a suitable mapping tool or investigate 3D Maps if it is available in your Excel version.

Why are some regions missing from my map?
Excel may not recognize those entries, the chart’s source range may omit them, or values may be blank or invalid. Check spelling and geographic context, confirm the selected data range, and test the affected locations in a small sample.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.