'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Maps Not Recognizing UK County Names
Question details
The user needs to map UK regional data using Excel Filled Maps, but the tool fails to plot specific locations like Central Bedfordshire.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a filled map visualization using regional UK data for geographical analysis.
- Observed behavior
- Excel Maps fails to recognize and plot certain locations because the inputted names do not match the Bing-supported UK county terminology.
Ensure your geographic data is formatted as an Excel Table or continuous range, and verify that you have an active internet connection so Excel can communicate with Bing Maps.
Use Bing-Supported UK Ceremonial County Names
Replace modern administrative district names in your dataset with the broader ceremonial county names recognized by Excel's Bing Maps integration.
Excel Filled Maps are powered by Bing, which uses a specific geographic dictionary to map regions. It often does not recognize modern administrative subsets (like Central Bedfordshire) and requires broader, traditional county names.
Check your map visualization for blank areas or regions that failed to plot, such as "Central Bedfordshire" or "Bath and North East Somerset".
Replace the unrecognized names in your spreadsheet with their broader ceremonial equivalents. For example, change "Central Bedfordshire" to "Bedfordshire".
Select your updated data range, navigate to the "Insert" tab on the ribbon, and click "Maps" followed by "Filled Map" to refresh the visualization with the recognized locations.
Create Powerful Data Visualizations with WPS Office
If you frequently work with complex regional data and want a fast, reliable spreadsheet tool, WPS Office is an excellent free alternative to Microsoft Excel. It offers a familiar interface, lightweight performance, and rich visualization capabilities.
- 1. Download WPS Office: Visit the official website to download and install the free WPS Office suite on your device.
- 2. Open Your Dataset: Launch WPS Spreadsheet and open your existing .xlsx data file directly.
- 3. Visualize Your Data: Select your data range, navigate to the Insert tab, and choose from a wide variety of standard and advanced charts.
Frequently Asked Questions
Why does Excel Maps show an error for Central Bedfordshire?
Excel Maps relies on Bing's geographic database, which prioritizes broader ceremonial counties like "Bedfordshire" rather than specific modern administrative districts like "Central Bedfordshire".
Do I need an internet connection to use Excel Filled Maps?
Yes, Excel requires an active internet connection to send your geographic data to Bing Maps for processing and rendering the map visualization.
How do I fix a completely blank map in Excel when using UK data?
Ensure your location column contains exactly matched, recognized UK county names. Additionally, you can add a secondary column labeled "Country" with "United Kingdom" in every row to give Bing Maps proper geographic context.
