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
NFPChris's avatar
NFPChris
Brass Contributor
Jun 18, 2019

To offer a wee update on this I'm still in the same position.

 

Going through the Excel support they were unable to help me and directed me to a Bing Maps feedback button which doesn't request contact details.  I've done this and also tried tweeting Excel, Bing Maps (not sure if it's really them) and Bing.

 

I haven't had any response.  Any suggestions?

SergeiBaklan's avatar
SergeiBaklan
MVP
Jun 19, 2019

NFPChris 

 

Chris, I have no contact details as well. Send frown from your Excel, Microsoft follow them. I'm not sure, but try to find the blog here about Maps Chart and ask your question mentioning the author here. Repeat on answers.microsoft.com. No warranty you'll have an answer, but at least more chances for that.

 

Perhaps Smitty Smith could add something.

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 19, 2019

    Smitty, thank you. 

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

    Chris/Sergei,

     

    If you convert your data to an Excel table, and rename B1 to County, then the chart will map with greater confidence (at least it did for me). 

     

    I've reached out the Map chart PM to see if he has any idea about the rest. It looks like the Bing mapping service isn't completely disambiguating the locales.

     

    Smitty

    MSFT

     

     

Resources