Forum Discussion
AGA66
Mar 10, 2021Copper Contributor
Mapping data about East Yorkshire in Excel
I have been trying to use the #FilledMap feature in Excel to map frequency data across the UK. I have worked out how to control all areas of the UK map except East Yorkshire (East Riding of Yorkshire...
AGA66
Mar 11, 2021Copper Contributor
Hello Sergei, thank you for your reply. You are absolutely correct, "East Riding of Yorkshire" does show up on the map, but in the wrong place! Also, you can control the same area with the label "Humberside" and "Kingston upon Hull" - the last of these is actually the real place that it is.
The more I look at this, the more I think it is a glitch in Excel that is displaying in the wrong place.
Take care
The more I look at this, the more I think it is a glitch in Excel that is displaying in the wrong place.
Take care
SergeiBaklan
Mar 11, 2021Diamond Contributor
Yes, there are some places which engine can't recognize properly. Quite often they are which were reorganized or changed the name within latest 10-15 years, but not only. Sometimes playing with place name helps, sometimes not.
In any case I'd recommend to Send a Frown from Help->Feedback of Excel.
- AGA66Mar 12, 2021Copper ContributorThank you again Sergei, I have provided feedback to MS through the Excel Help feature. I'll see what happens next...
- spamthehammerJul 23, 2021Copper Contributor
It appears "East Riding of Yorkshire" now works but doesn't populate Hull. I have used an additional row "Humberside" which now shades all of the East Riding. AGA66 . Using the UK Ceremonial Counties however leaves the rest of the UK like swiss cheese.