Forum Discussion

Paul T's avatar
Paul T
Copper Contributor
Feb 09, 2018
Solved

Devon, UK does not show on Excel Maps

i.  I am plotting counties of the UK - specifically the South West of England. This includes Cornwall, Devon, Somerset and Dorset. Excel maps WILL NOT plot Devon, no matter what I call it. I have t...
Charts & Visualizing Data
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 09, 2018

    Paul, did you try Devonshire?

Bill_Crawford's avatar
Bill_Crawford
Copper Contributor
Mar 31, 2019

SergeiBaklan

Hi Sergie,

 

Hope you don't mind. I've attached an update to your UK Maps file correcting the data for Scotland. There are currently 32 council areas (counties) in Scotland which I have listed. There are still some errors which I think are bugs in the map chart application (see Below). 

 

Errors for Scotland
Renfrewshire, West Dunbartonshire and Midlothian are correct counties but do not show on the map.
Using the names Hebrides and Ayrshire show the areas on the map but these areas are incorrectly named.
Hebrides should be Na h-Eileanan an Iar (Gaelic for Western Isles)
Ayrshire should be South Ayrshire.

 

Hope this helps others in the community.

Dipples's avatar
Dipples
Copper Contributor
Sep 10, 2020

Bill_Crawford 

 

Thanks for sharing your spreadsheet. I encountered this problem and found what appears to be a fix (of sorts) for those Scottish regions that don't show up (Renfrewshire, West Dunbartonshire and Midlothian) : if you remove "Scotland" from the "State" column, they pull through. Don't ask me why (I stumbled upon it completely by accident!). I don't know if this works with the ones in England as I've not tried it. Hope that helps some people.