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