How to Fix Excel Maps Not Recognizing Specific Counties
Question details
The user is trying to create a Filled Map in Excel using county-level data, but the map fails to recognize and plot specific locations, such as Garden County, Nebraska.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a Filled Map visualization using state, county name, and FIPS code data.
- Observed behavior
- The specified county remains entirely blank on the rendered map, despite the data and FIPS codes being formatted correctly.
Ensure your device has a stable internet connection, as Excel Maps relies entirely on the online Bing Maps service to process and render geographic locations.
Isolate the Issue with a Test Workbook
Create a completely clean dataset to determine if the plotting issue is tied to your specific spreadsheet file or if it is a broader Bing Maps data limitation.
Excel Maps uses Bing location data to render boundaries. Occasionally, Bing's backend datasets contain incomplete geographic records for specific counties. By creating a minimal test file, you can verify if the map engine itself is rejecting the county.
Open Excel and click on File > New to create a completely blank workbook.
Create three columns labeled 'State', 'County', and 'FIPS Code'. Enter 'Nebraska', 'Garden County', and its exact FIPS code into the first row.
Select this small data range, navigate to the Insert tab on the ribbon, and click Maps > Filled Map.
Check the generated map. If the county still remains blank, it confirms a limitation or omission in the Bing Maps database rather than an error in your original document.

Report the Geographic Limitation via Excel Feedback
Since the map boundary data is controlled by Bing, missing county definitions must be reported to the development team to be permanently fixed.
Visualize Your Data Without Hassle in WPS Office
If you are frustrated by limitations and missing features in Microsoft Excel, consider switching to WPS Office. It provides robust spreadsheet tools, extensive charting options, and flawless compatibility with all your data files.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your computer.
- 2. Open your datasets: Launch WPS Spreadsheet and open your existing .xlsx or .csv data files seamlessly.
- 3. Create new visualizations: Select your geographic or numerical data and insert built-in charts to effectively present your metrics.

Frequently Asked Questions
Why does my Excel Map leave certain counties blank?
Excel Maps rely entirely on Bing's geographic data to draw boundaries. If the Bing database has outdated, ambiguous, or missing records for a specific county, Excel will fail to plot it even if your spreadsheet data is 100% accurate.
Will using a FIPS code force the Excel Map to recognize the county?
Including a FIPS code significantly improves geographic accuracy and helps disambiguate locations with similar names. However, if the underlying map service completely lacks the boundary drawing data for that specific FIPS code, it will still remain blank.
Do I need an internet connection to use Excel Filled Maps?
Yes. Excel Maps are not stored locally on your device. You must have an active internet connection to communicate with the Bing Maps service, which interprets your data and renders the map images.
How long does it take for Microsoft to fix a missing map location?
Resolution times vary greatly. Because the issue relies on an update to the Bing Maps dataset rather than a simple Excel software patch, it can take several months for user feedback to result in visible map boundary updates.




