Hi,Apologies if this has been answered elsewhere but I'm trying to create a map chart for Scottish Local Authorties (Council regions) and I have all of their official names but the Maps chart isn't having it. Is there a list somewhere for how I should be naming these or am I missing anything else? I've attached a picture of my data.Thanks,Chris

NFPChris Hi Chris Map Charts is quite sensitive to the names. It has no idea about what is Row Labels and Local Authority how you name your columns. Second, it won't recognize Moray but recognises County of Moray. It's no warranty it works with everything, but first try to transform you data in this way

Thank you SergeiBaklan . Sensitive is a very polite word for it! Thanks for your help.I have found the solution to all but 2 of the local authorities - Angus & West Dunbartonshire. I've tried adding County to the end and County of to the front as well as City but without joy. Any suggestions?

Bizarrely the Gaelic name for Angus, Comhairle Aonghais, has worked but I still can't get anything for West Dunbartonshire.

NFPChris , Hi Chris, It works in my case Try to put it into another place of your table.

Thanks for checking SergeiBaklan. The area in your map that is circled is actually Argyll & Bute. I'm pretty sure West Dunbartonshire is the missing bit in the centre. Microsoft don't seem to believe in West Dunbartonshire!

Maps Data for Scotland | Microsoft Community Hub

SergeiBaklan
MVP
May 23, 2019
NFPChris

Hi Chris

Map Charts is quite sensitive to the names. It has no idea about what is Row Labels and Local Authority how you name your columns. Second, it won't recognize Moray but recognises County of Moray. It's no warranty it works with everything, but first try to transform you data in this way
- NFPChris
  Brass Contributor
  May 23, 2019
  Thank you SergeiBaklan . Sensitive is a very polite word for it! Thanks for your help.
  
  I have found the solution to all but 2 of the local authorities - Angus & West Dunbartonshire. I've tried adding County to the end and County of to the front as well as City but without joy.
  
  Any suggestions?
  - NFPChris
    Brass Contributor
    May 23, 2019
    Bizarrely the Gaelic name for Angus, Comhairle Aonghais, has worked but I still can't get anything for West Dunbartonshire.

Forum Discussion

Maps Data for Scotland

Resources