Fix Excel Geographic Map No Data for Brandenburg an der Havel
Question details
The user needs to determine why Excel displays Brandenburg an der Havel as gray with a No data label in a geographic map despite a value being present in the source data.

- Product
- Microsoft Excel geographic map chart
- Device & OS
- not provided
- Scenario
- Creating or reviewing a filled geographic map that includes Brandenburg an der Havel.
- Observed behavior
- The location appears gray and is labeled No data instead of displaying the supplied value.
Keep the location column and value column visible in the worksheet so you can verify the exact text and cell values. Check that your Excel installation includes the Map chart feature and has an internet connection for geographic recognition.
Make the Brandenburg an der Havel location unambiguous
Use this solution when Excel may be matching the place name to the wrong area or cannot recognize it as a supported geographic location.
Map charts rely on Excel's geographic data matching. Adding state and country context can help Excel distinguish Brandenburg an der Havel from similarly named locations or unsupported administrative areas.
In a new worksheet column, enter a complete location such as "Brandenburg an der Havel, Brandenburg, Germany" for the affected row.
Select the location cell, press F2, and check for leading or trailing spaces, unusual punctuation, or spelling differences. Use the TRIM function in a helper cell if needed.
Select the location and value columns, then choose Insert > Maps > Filled Map. If the chart already exists, right-click it and choose Select Data to confirm that the corrected location row is included.

Convert the mapped value to a real number
Use this solution when the location is recognized but its associated value is stored as text, blank, or an error.
Review map filters, formatting, and Excel feature support
Use this solution when the row is valid but remains gray because the chart excludes it or the installed Excel version has Map chart limitations.
Use WPS Office for Compatible Spreadsheet Workflows
If Excel's geographic matching or Map chart behavior prevents you from presenting the data as expected, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong compatibility for opening, editing, and sharing Excel workbooks. You can migrate your data seamlessly and use standard charts or formatted tables to present regional values clearly.

Frequently Asked Questions
Why does Excel show No data when the value cell is not blank?
Excel can show No data when it cannot match the location text to a supported geographic entity or when the linked value is stored as text instead of a number. Verify the location label and convert the value to a numeric cell.
What location text should I use for Brandenburg an der Havel in an Excel map?
Try a fully qualified label such as "Brandenburg an der Havel, Brandenburg, Germany." Enter it in the source location column, then update the chart through Chart Design > Select Data or recreate it from Insert > Maps > Filled Map.
Can extra spaces cause an Excel Map chart to miss a location?
Yes. Leading spaces, trailing spaces, nonbreaking spaces, and inconsistent punctuation can interfere with geographic matching. Edit the cell directly or use TRIM in a helper column before using the cleaned text in the map data.
How can I tell whether a map value is text instead of a number?
Select the value cell and check its alignment, formula bar, and number format on Home > Number. Text values often have an apostrophe or are treated as General/Text; use Data > Text to Columns > Finish to convert compatible values.
What should I check if only one area is gray in an Excel Filled Map?
Check the spelling and geographic context for that row first, then confirm the row is included in the chart source range and is not filtered out. Finally, verify that the value is numeric and that your Excel version supports the required map geography level.




