Forum Discussion
excel isn't recognising the city of york in the uk
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.