Forum Discussion

NFPChris's avatar
NFPChris
Copper 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
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
Copper 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
    Copper 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.

      • NFPChris's avatar
        NFPChris
        Copper Contributor
        Jun 21, 2019

        Thank you for the replies.  Thanks SergeiBaklan for bringing in reinforcements!  I have now added the question to Answers. I couldn't find an appropriate blog to contact an author though.

         

        Thanks for trying Noel Slevin , Forfarshire seems to replace Angus which would make sense.

         

        Thanks Smitty Smith , unfortunately I don't seem to be able to access Data Types.  I'm using Office 365 Pro Plus and have just done an update but I still don't have these options.  It sounds like it's the same problem if it's plotting all but East Ayrshire though, seems bizarre that it'd be a different Local Authority that'd cause the problem.  From your original post regarding the counties and greater confidence I do know from checking that the 31/32 that I do now have plotted are correct and the missing piece of the jigsaw is exactly where West Dunbartonshire lies.  

         

         

      • NFPChris's avatar
        NFPChris
        Copper Contributor
        May 24, 2019

        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! 

Resources