Fix Missing Locations in Excel Map Charts and Bing Maps
Question details
Troubleshoot country, state, region, or city values that do not appear when data is plotted on an Excel Map Chart or Bing map.
- Product
- Microsoft Excel Map Charts and Bing Maps
- Device & OS
- not provided
- Scenario
- The user is mapping geographic spreadsheet data and needs every intended location to be recognized and displayed.
- Observed behavior
- Some locations, regions, or data points are missing from the map because the map cannot reliably identify, support, or include the supplied geographic values.
Identify whether you are using an Excel Map Chart, the Bing Maps add-in, or another mapping application, because recognized geographic levels and available filters can differ. Review the source column to confirm it contains location values rather than mixed labels, blanks, or formula errors.
Standardize location names and add geographic context
Use this method when a map does not recognize certain cities, regions, states, or countries.
Map services can omit a location when its name is ambiguous, misspelled, inconsistently formatted, or missing its country or state context. A separate country or region column can help the mapping service interpret the data correctly.
In Excel, review the cells used for the map and remove leading or trailing spaces with a helper formula such as =TRIM(A2). Correct spelling differences and use one consistent naming convention, such as “United States” rather than a mix of “US,” “U.S.A.,” and “United States of America.”
For ambiguous values such as “Springfield,” add a neighboring State/Province and Country/Region column. For example, use “Springfield” with “Illinois” and “United States,” or create a combined value such as “Springfield, Illinois, United States.”
Select the location cells, then choose Data > Data Types > Geography in Excel when the option is available. Check whether Excel recognizes the returned geographic entity and correct entries marked with a question mark or an incorrect match.
Make sure the values that determine map shading, bubbles, or labels are stored as numbers. Select the value column and use Home > Number Format to apply Number or General instead of keeping numeric values as text.
Check map coverage, filters, and refresh the visualization
Use this method after cleaning the data if locations are still absent from an existing map.
Prepare Clean Geographic Data in WPS Spreadsheet Before Mapping
If an Excel or Bing Maps feature does not recognize your locations, use WPS Office to clean and organize the source worksheet with a familiar spreadsheet interface. WPS Office is free, lightweight, and compatible with common Microsoft Office formats, making it easy to standardize location fields and move the corrected file back into your preferred mapping workflow.
Frequently Asked Questions
Why does Excel show some countries but not others on a map chart?
Excel may not recognize inconsistent or abbreviated country names, or the missing entries may be excluded by a chart filter. Use complete, consistent country names, check Chart Filters, and refresh the chart.
How can I map cities with the same name in different places?
Add State/Province and Country/Region columns beside the city column. You can also combine them into a single value, such as “Portland, Oregon, United States,” before creating the map.
Do map chart values need to be numbers?
Yes, the measure used for shading, bubbles, or comparisons should be numeric. Select the value cells and use Home > Number Format to convert text-formatted numbers to Number or General.
How do I check whether Excel recognizes a location?
Select the location cells and choose Data > Data Types > Geography. Excel will attempt to match each entry to a geographic entity; correct entries that show an incorrect match or require a selection.
What should I do if a cleaned location still does not display?
Check whether the mapping service supports that geographic level, such as a small district or local boundary. Then create a new map with Insert > Maps > Filled Map after confirming the source range includes the missing row.
