Chart & Visualization Issues

Fix Excel Geography Data Not Plotting UK Place Names on Map

Rana Garcia Sep 30, 2026 868 views

Question details

Excel recognizes UK place names as geography data and displays coordinates, but fails to plot the locations on a map chart.

How to Fix Excel Geography Data Not Plotting UK Place Names on a Map

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a map chart using UK geographic data, such as census information, where specific highlighted places do not appear.
Observed behavior: The place names are successfully converted to the Geography data type, but the map chart remains blank for those specific locations due to ambiguous geographic entities.

Before you start

Ensure you have an active internet connection, as Excel relies on Bing Maps online services to accurately resolve and plot Geography data types.

Solution 1Recommended

Provide Geographic Context by Adding Columns

Adding broader geographic columns helps Excel disambiguate place names that might exist in multiple regions.

Excel can struggle to plot a UK place name if it shares its name with another location globally. By providing a broader context, Bing Maps can pinpoint the exact location you intend to plot.

Insert Context Columns

Insert new columns next to your place names for 'County' and 'Country'.

Populate the Data

Fill the 'Country' column with 'United Kingdom' and add the specific county for the ambiguous place names.

Recreate the Map Chart

Highlight all columns (Place, County, Country, and your numerical data) and go to the Insert tab > Maps > Filled Map.

Provide Geographic Context by Adding Columns

Hierarchical Data Mapping: Excel map charts automatically read hierarchical data from left to right. Placing 'Country' then 'County' before the place name improves plotting accuracy.

Solution 2

Manually Resolve Ambiguous Data Entities

Use the Data Selector pane to manually choose the correct geographic entity when Excel is unsure.

Solution 3

Create a Sanitized Sample for Support

If standard disambiguation fails, you may need to share a sanitized workbook with a support community for deeper inspection.

Free Microsoft Office alternative

Experience Seamless Data Visualization with WPS Office

If troubleshooting complex map chart errors in Excel is slowing down your workflow, try WPS Office. It offers a lightweight, completely free core spreadsheet experience with high compatibility and an intuitive interface for all your data analysis needs.

1. Download and Install: Visit the official WPS website to download and install the free software suite.
2. Open Your Data: Launch WPS Spreadsheets and seamlessly open your existing .xlsx data files.
3. Visualize Your Data: Highlight your dataset, click the Insert tab, and choose from various intuitive chart options.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and formatsRich set of standard chart types for versatile data visualizationLightweight software with fast installation and lightning-fast loading timesFamiliar user interface requiring zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel recognize my geography data but fail to plot it visually?

Excel relies on Bing Maps for geography data. If a UK place name is ambiguous or exists in multiple regions, Bing Maps may fetch text coordinates but fail to render the accurate map polygon visually without additional context like county or country.

How do I fix the question mark icon next to my geography data?

A question mark indicates Excel could not confidently resolve the location. Click the icon to open the Data Selector pane, search for the precise location with additional context, and manually select the correct match.

Are UK postcodes supported in Excel map charts?

Yes, Excel can map UK postcodes. However, formatting them consistently and ensuring they are correctly assigned the Geography data type is crucial for Bing Maps to plot them accurately.

Excel & Data Problems