Forum Discussion
NFPChris
May 23, 2019Brass Contributor
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...
NFPChris
May 23, 2019Brass Contributor
Bizarrely the Gaelic name for Angus, Comhairle Aonghais, has worked but I still can't get anything for West Dunbartonshire.
Noel Slevin
Jun 20, 2019Copper Contributor
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.
- NFPChrisJun 21, 2019Brass Contributor
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.
- SergeiBaklanJun 21, 2019MVP
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 SmithJun 21, 2019
Microsoft
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