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?

Martin Radford's avatar
Martin Radford
Copper Contributor
Sep 04, 2018

Hi Paul

I'm trying to do the same thing, could you give me the list of counties you're using (inc. Wales, Scotland and NI?) there is something odd with the way it recognises counties as I've  got Devon in my list and it's working fine. I'm having a problem with what on earth (no pun intended) the other options for Essex, Suffolk and Norfolk are!!

thanks

martin

 

SergeiBaklan's avatar
SergeiBaklan
MVP
Sep 04, 2018

Hi Martin,

 

It very depends not only on counties names, but also on how you name your column. If, for example, England, NI, etc you call Countries you have one picture. If States - another. 

 

In attached map counties you mentioned are shown. However, not sure all counties are recognized.

  • Bill_Crawford's avatar
    Bill_Crawford
    Copper Contributor
    Apr 01, 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. 

    • rlaan1's avatar
      rlaan1
      Copper Contributor
      Apr 02, 2019

      Bill_Crawford and@Sergei Baklan thanks a lot that works great for the counties. Unfortunately only part of the level 1 regions (12 in total) are recognised. Have asked Bing to add them as provinces or states in the UK. the 12 are:

       

      • UKC. North East.
      • UKD. North West.
      • UKE. Yorkshire and the Humber.
      • UKF. East Midlands.
      • UKG. West Midlands.
      • UKH. East of England.
      • UKI. Greater London.
      • UKJ. South East.
      • Wales
      • Scotland
      • Northern Ireland
    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Apr 01, 2019

      Hi Bill_Crawford ,

       

      Thank you, I guess that will be useful for the community. I'd suggest you to send a frown to Microsoft, it's in File->Feedback

  • Martin Radford's avatar
    Martin Radford
    Copper Contributor
    Sep 06, 2018

    thank you, that's exactly what I was looking for.

Resources