Forum Discussion

NFPChris's avatar
NFPChris
Brass Contributor
May 23, 2019

Maps Data for Scotland

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 

Charting
data
excel
Maps
Scotland
  • SergeiBaklan's avatar
    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's avatar
      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's avatar
        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.

         

Resources