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
MVP
Jun 21, 2019

NFPChris 

 

I didn't find here Smitty Smith post about geography data type, perhaps it was deleted. I tried West Dunbartonshire with geography data type as well, that didn't help.

Smitty Smith's avatar
Smitty Smith
Icon for Microsoft rankMicrosoft
Jun 21, 2019

Chris/Sergei,

 

[quote]I didn't find here @Smitty Smith post about geography data type, perhaps it was deleted. [quote]

 

Sorry about that. I posted a solution from the Excel team with data types, but it turns out there were some issues that need to be addressed, so I deleted it.

 

They went back to the drawing board, and were able to come up with good results with normal text by adding a Country/UK column to aid with disambiguation, then mapping Scottish Councils with "County" for the Council column, and "Province" header for Scotland. There's a hangup with West Dumbartonshire, but that's been sent to the Bing team to investigate. It should be fixed and in production in a few weeks.

 

And here's a link to the new workbook: ScotlandCouncils.xlsx

 

Thanks for the interesting scenario! It's definitely going to help with geography data type definitions.

 

Smitty

  • NFPChris's avatar
    NFPChris
    Brass Contributor
    Apr 05, 2021

    Hi, Smitty Smith.  Having been reminded of this thread after Andrew's post I've read back through it and saw your post.  Do you know if this should be active now, I'm wondering if there's something else I need to do for West Dunbartonshire but I don't want to go try everything again if it's still not been resolved.

     

    Thanks 🙂 

  • NFPChris's avatar
    NFPChris
    Brass Contributor
    Apr 05, 2021

    andrewomalley Hi Andrew, have you been able to do this? I still have the same issue with West Dunbartonshire not appearing.  Still rather nippy as I need to fill this in myself for each Quarter's report.

     

    I had a recent stab of this in Data Studio too but it still wasn't perfect.  Seemed to think Midlothian was in Texas.

     

    I don't have a suggestion for electoral map within Excel, but maybe you could use something like mapchart.net .

     

     

     

     

     

  • andrewomalley's avatar
    andrewomalley
    Copper Contributor
    Mar 31, 2021

    SergeiBaklan 

     

    Hi everyone - sorry to crash this thread after so long. It seems like mapping Scottish councils now works - congratulations. 

     

    I wonder if you could help me with an approach to map Holyrood constituencies data?

     

    Andrew

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jul 26, 2019

    Hi Chris,

     

    Update shall be in logic on Microsoft servers site, our client applications only pick-up information from them and present in proper form.

     

    Have no idea about the Microsoft plans to fix that issue.

  • NFPChris's avatar
    NFPChris
    Brass Contributor
    Jul 26, 2019

    Hi guys,

     

    Our Office applications have now received an update (bit retro looking!) and that's included the Data Types but my West Dunbartonshire remains greyed out.

     

    Has there been any update on this?


    Thanks,

    Chris

  • NFPChris's avatar
    NFPChris
    Brass Contributor
    Jun 24, 2019
    Whoop! Thanks again guys.

    I'll leave Data Types for another day :D

Resources