Forum Discussion
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...
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
Hi Smitty,
Thank you for this update. Yes, Map Charts is quite sensitive to column names, but not only. Sometimes it's enough to rename the place like County of Stirling instead of Stirling (what Chris did). Sometimes order of records matters.
On the other hand it could ignore such dancing with names, e.g. I removed UK column and renamed Scotland to State - result is exactly the same (second sheet attached)
However, whatever we do West Dunbartonshire remains the black hole.