SOLVED

Scotland Councils

%3CLINGO-SUB%20id%3D%22lingo-sub-3528638%22%20slang%3D%22en-US%22%3EScotland%20Councils%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3528638%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20Appreciate%20there%20has%20been%20some%20discussion%20on%20this%20already%20but%20I%20can't%20get%20Scottish%20Councils%20to%20appear%20on%20my%20Excel%20Map.%26nbsp%3B%20Also%20for%20Councils%20that%20are%20appearing%2C%20some%20are%20showing%20no%20data%20when%20I%20click%20on%20the%20map%20even%20if%20the%20name%20of%20the%20council%20is%20recognised.%3C%2FP%3E%3CP%3EIt's%20my%20first%20time%20on%20the%20Tech%20Community%20so%20apologies%20if%20I%20have%20not%20followed%20the%20correct%20etiquette%20in%20posting%20an%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3528638%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3530866%22%20slang%3D%22en-US%22%3ERe%3A%20Scotland%20Councils%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3530866%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1274555%22%20target%3D%22_blank%22%3E%40LizSams%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETool%20is%20quite%20sensitive%20to%20column%20and%20place%20names.%20In%20initial%20generated%20list%20I%20changed%203%20names%2C%20it%20looks%20like%20it%20works.%20But%20I'm%20not%20very%20familiar%20with%20the%20geography%20of%20Scotland%2C%20sorry.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20851px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20851px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20851px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F382198iFE71EECFD8104FA3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3531870%22%20slang%3D%22en-US%22%3ERe%3A%20Scotland%20Councils%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3531870%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20-%20I%20had%20identical%20spelling%20but%20your%20sheets%20works!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22West%20Dunbartonshire.png%22%20style%3D%22width%3A%20424px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22West%20Dunbartonshire.png%22%20style%3D%22width%3A%20424px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F382317i6E95B3936A635705%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22West%20Dunbartonshire.png%22%20alt%3D%22West%20Dunbartonshire.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi.  Appreciate there has been some discussion on this already but I can't get Scottish Councils to appear on my Excel Map.  Also for Councils that are appearing, some are showing no data when I click on the map even if the name of the council is recognised.

It's my first time on the Tech Community so apologies if I have not followed the correct etiquette in posting an issue.

 

Thanks 

2 Replies
best response confirmed by LizSams (New Contributor)
Solution

@LizSams 

Tool is quite sensitive to column and place names. In initial generated list I changed 3 names, it looks like it works. But I'm not very familiar with the geography of Scotland, sorry.

image.png

@Sergei Baklan 

 

Thank you so much - I had identical spelling but your sheets works!West Dunbartonshire.png