Forum Discussion
Maps Data for Scotland
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
I'll leave Data Types for another day :D
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 .
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
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.
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
