Chart & Visualization Issues

Fix Excel Geography Maps When Indonesian Regions Are Not Recognized

Adam DavisAdam Davis Nov 12, 2026 869 views

Question details

The user needs Excel to recognize Indonesian regencies or other ambiguous geographic names so they can appear correctly in a Map chart.

Fix Excel Geography Maps When Indonesian Regions Are Not Recognized
Product
Microsoft Excel Geography data type and Map chart
Device & OS
not provided
Scenario
A worksheet contains regional place names that are being used for geographic data or a Map chart.
Observed behavior
Some locations remain gray because Excel cannot confidently identify them as geographic regions or matches them to the wrong location.
Before you start

Make sure the region names are stored as text in a single column and that the workbook has an internet connection available for Excel data types. Check the official spelling of each regency, city, province, or country before assigning locations.

Solution 1Recommended

Assign the Geography data type and correct ambiguous matches

Use this method when Excel displays a question mark or cannot determine which geographic location a region name represents.

Excel uses online geographic data to identify locations. A question mark next to a value means that more than one possible location was found or that Excel needs additional information.

1
Select the location names

In Excel, select the cells that contain the regency, city, province, or other region names.

2
Apply the Geography data type

On the Data tab, select Data Types > Geography. Wait for Excel to analyze the selected entries.

3
Review question-mark entries

Click the question mark icon that appears beside an ambiguous cell, then choose the correct location from Excel's suggestion list.

4
Confirm the resolved location

Click a recognized Geography cell and use the Insert Data button that appears to review fields such as Province, Country/Region, or Population.

5
Refresh the Map chart

Select the Map chart, then use Chart Design > Refresh Data if available, or reselect the corrected geographic data range to update the map.

Assign the Geography data type and correct ambiguous matches
Recognized locations can be mapped: Once Excel identifies the correct Geography entity, the corresponding region should be available for use in a Map chart instead of remaining gray.
Free Microsoft Office alternative

Create and Edit Excel-Compatible Regional Data Workbooks With WPS Office

If Microsoft Excel's online Geography data service does not recognize a location, WPS Office provides a free, lightweight office alternative for organizing, cleaning, and visualizing regional worksheet data. Its familiar spreadsheet interface helps you move from Excel with minimal adjustment while maintaining compatibility with your existing files.

Clean and standardize regency, province, and country labels before chartingOpen and edit Microsoft Excel .xlsx and .xls workbooksUse a familiar spreadsheet interface for formulas, tables, and chartsLightweight installation with seamless migration from Microsoft Office files
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a question mark next to a region name?

A question mark means Excel found multiple possible geographic matches or could not identify the location with enough confidence. Click the icon and select the correct result from the suggested locations.

How can I make Excel recognize an Indonesian regency?

Add the regency's province and country, such as "[Regency], [Province], Indonesia," in a combined column. Then select that column and choose Data > Data Types > Geography.

Why are some areas gray in my Excel Map chart?

Gray areas commonly indicate that Excel did not recognize the location, the chart source range is incomplete, or the map is set to a geographic area that excludes the data. Verify the Geography match and check Chart Design > Select Data.

Can I use separate columns for city, province, and country in Excel?

Yes. Keep the columns separate for clarity, then create a helper column that combines the place, province, and country. Apply Data > Data Types > Geography to the helper column.

Does Excel Geography require an internet connection?

Yes. Excel's linked Geography data type uses online services to identify locations and retrieve geographic fields, so an active connection is normally required.