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

       

      • Noel Slevin's avatar
        Noel Slevin
        Copper Contributor
        Jun 20, 2019

        NFPChris it also appears to respond to Forfarshire. West Dunbartonshire is proving impossible, however. I've tried everything I can think of, in English, Scots and Gaelic.

Resources