Forum Discussion
excel isn't recognising the city of york in the uk
i really hope someone can help with this, i've got to believe it's already been figured out by someone. i have a map chart of the uk with all counties and cities covered except for York, i've tried City of York among other variants but none seem to work. any ideas would be gratefully received
3 Replies
- CameronTaylor1998Iron Contributor
With Excel maps, the issue can be either identifying York or finding a supported boundary to fill. Those aren’t quite the same thing.
Try putting the location details in separate columns rather than changing the name alone:
Location Country Value York United Kingdom 1 Select the Location and Country cells and try Data → Geography. If Excel offers a choice of matches, select York in England. Then recreate the map using the location, country, and value columns.
If you want the whole City of York council area shaded, make sure the match represents that local-authority area rather than just the city. York is a unitary authority, so mixing it with counties and city locations can make a filled map difficult to resolve.
If Excel recognises York correctly but still leaves that area blank, trying more spellings may not help: the map service may not resolve the required boundary for that chart. Filled Map charts don’t let you manually draw or import a missing boundary. For a dot marking the city instead, Excel’s 3D Maps on supported Windows desktop versions can use latitude and longitude.
- maria8Occasional Reader
This is a known limitation with Excel's UK map data, rather than necessarily an issue with your spreadsheet.
There is actually a Microsoft Q&A discussion specifically mentioning York not appearing in Excel Map Charts.
Try this workaround
1\. Add three separate columns:
- Country: `United Kingdom`
- County: `York`
- Value: your data
2\. Use the standard Insert → Maps → Filled Map option rather than relying on the Geography data type.
3\. If York still doesn't appear, unfortunately Excel's underlying Bing Maps geographic boundaries may not support that particular administrative area.
My recommendation: Don't waste too much time trying different spellings. This appears to be a gap in Microsoft's underlying UK mapping data.
- AmezingtechsataraIron Contributor
York is one of those names that trips Excel up, because there's more than one York in the world and the map chart can't tell which one you mean on its own. Microsoft's map chart help actually calls this out — when a place name could be several places, some points just won't map.
The fix that works is to give Excel a second, higher-level column in its own cell, next to the city name. So keep York in one column and put North Yorkshire in the next, and United Kingdom in another if you have it. Don't put them together in one cell as York, England, because Excel needs each level separate to use it for disambiguation. Then select both columns when you build the chart, or convert the city column through Data, Data Types, Geography and pick the right York if Excel offers you a choice.
That second column is also what the help page suggests when a geography data type maps incorrectly — include an admin field like the county or country. Give that a try and the York point should land on the UK map with the rest of them.