SOLVED
Home

Devon, UK does not show on Excel Maps

%3CLINGO-SUB%20id%3D%22lingo-sub-154271%22%20slang%3D%22en-US%22%3EDevon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-154271%22%20slang%3D%22en-US%22%3E%3CP%3Ei.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20plotting%20counties%20of%20the%20UK%20-%20specifically%20the%20South%20West%20of%20England.%20This%20includes%20Cornwall%2C%20Devon%2C%20Somerset%20and%20Dorset.%20Excel%20maps%20WILL%20NOT%20plot%20Devon%2C%20no%20matter%20what%20I%20call%20it.%20I%20have%20tried%3A%3C%2FP%3E%0A%3CP%3EDevon%3C%2FP%3E%0A%3CP%3EUK%2C%20Devon%3C%2FP%3E%0A%3CP%3EDevon%2C%20UK%3C%2FP%3E%0A%3CP%3EDevon%2C%20United%20Kingdom%3C%2FP%3E%0A%3CP%3EDevon%2C%20GB%3C%2FP%3E%0A%3CP%3EDevon%2C%20GB%2C%20United%20Kingdom%3C%2FP%3E%0A%3CP%3EOn%20Bing%20maps%2C%20Devon%20comes%20up%20absolutely%20fine.%20What%20is%20the%20problem%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-154271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392779%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392779%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F311536%22%20target%3D%22_blank%22%3E%40Bill_Crawford%3C%2FA%3E%26nbsp%3Band%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthanks%20a%20lot%20that%20works%20great%20for%20the%20counties.%20Unfortunately%20only%20part%20of%20the%20level%201%20regions%20(12%20in%20total)%20are%20recognised.%20Have%20asked%20Bing%20to%20add%20them%20as%20provinces%20or%20states%20in%20the%20UK.%20the%2012%20are%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EUKC.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ENorth%20East%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EUKD.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ENorth%20West%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EUKE.%20Yorkshire%20and%20the%20Humber.%3C%2FLI%3E%3CLI%3EUKF.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EEast%20Midlands%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EUKG.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EWest%20Midlands%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EUKH.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EEast%20of%20England%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EUKI.%20Greater%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ELondon%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EUKJ.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESouth%20East%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EWales%3C%2FLI%3E%3CLI%3EScotland%3C%2FLI%3E%3CLI%3ENorthern%20Ireland%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392166%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392166%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F311536%22%20target%3D%22_blank%22%3E%40Bill_Crawford%3C%2FA%3E%20%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%2C%20I%20guess%20that%20will%20be%20useful%20for%20the%20community.%20I'd%20suggest%20you%20to%20send%20a%20frown%20to%20Microsoft%2C%20it's%20in%20File-%26gt%3BFeedback%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20456px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F100877i11534F755C8DA6B9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391626%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391626%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F311536%22%20target%3D%22_blank%22%3E%40Bill_Crawford%3C%2FA%3E%26nbsp%3B%2C%20the%20mysteries%20of%20what%20Americans%20think%20our%20counties%20are%20called%20continues%20to%20amaze.%20MInd%20you%2C%20we're%20not%20the%20only%20ones.....%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20298px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F100731iBB9613502067F0C1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22fox.jpg%22%20title%3D%22fox.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391594%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391594%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%3C%2FP%3E%3CP%3EHi%20Sergie%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20don't%20mind.%20I've%20attached%20an%20update%20to%20your%20UK%20Maps%20file%20correcting%20the%20data%20for%20Scotland.%20There%20are%20currently%2032%20council%20areas%20(counties)%20in%20Scotland%20which%20I%20have%20listed.%20There%20are%20still%20some%20errors%20which%20I%20think%20are%20bugs%20in%20the%20map%20chart%20application%20(see%20Below).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EErrors%20for%20Scotland%3CBR%20%2F%3ERenfrewshire%2C%20West%20Dunbartonshire%20and%20Midlothian%20are%20correct%20counties%20but%20do%20not%20show%20on%20the%20map.%3CBR%20%2F%3EUsing%20the%20names%20Hebrides%20and%20Ayrshire%20show%20the%20areas%20on%20the%20map%20but%20these%20areas%20are%20incorrectly%20named.%3CBR%20%2F%3E%3CSTRONG%3EHebrides%3C%2FSTRONG%3E%20should%20be%20%3CSTRONG%3ENa%20h-Eileanan%20an%20Iar%3C%2FSTRONG%3E%20(Gaelic%20for%20Western%20Isles)%3CBR%20%2F%3E%3CSTRONG%3EAyrshire%3C%2FSTRONG%3E%20should%20be%20%3CSTRONG%3ESouth%20Ayrshire%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%20others%20in%20the%20community.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-242522%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242522%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%2C%20that's%20exactly%20what%20I%20was%20looking%20for.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241672%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241672%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Martin%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20very%20depends%20not%20only%20on%20counties%20names%2C%20but%20also%20on%20how%20you%20name%20your%20column.%20If%2C%20for%20example%2C%20England%2C%20NI%2C%20etc%20you%20call%20Countries%20you%20have%20one%20picture.%20If%20States%20-%20another.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20attached%20map%20counties%20you%20mentioned%20are%20shown.%20However%2C%20not%20sure%20all%20counties%20are%20recognized.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241604%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241604%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Paul%3C%2FP%3E%3CP%3EI'm%20trying%20to%20do%20the%20same%20thing%2C%20could%20you%20give%20me%20the%20list%20of%20counties%20you're%20using%20(inc.%20Wales%2C%20Scotland%20and%20NI%3F)%20there%20is%20something%20odd%20with%20the%20way%20it%20recognises%20counties%20as%20I've%26nbsp%3B%20got%20Devon%20in%20my%20list%20and%20it's%20working%20fine.%20I'm%20having%20a%20problem%20with%20what%20on%20earth%20(no%20pun%20intended)%20the%20other%20options%20for%20Essex%2C%20Suffolk%20and%20Norfolk%20are!!%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3Emartin%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20766px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44746iF9BFD9DD2E72FA0E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Map.PNG%22%20title%3D%22Excel%20Map.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-154307%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-154307%22%20slang%3D%22en-US%22%3E%3CP%3ETHANK%20YOU!%3C%2FP%3E%0A%3CP%3EI%20was%20too%20close%20to%20the%20elephant%20there...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-154281%22%20slang%3D%22en-US%22%3ERe%3A%20Devon%2C%20UK%20does%20not%20show%20on%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-154281%22%20slang%3D%22en-US%22%3E%3CP%3EPaul%2C%20did%20you%20try%20Devonshire%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Paul T
New Contributor

i. 

I am plotting counties of the UK - specifically the South West of England. This includes Cornwall, Devon, Somerset and Dorset. Excel maps WILL NOT plot Devon, no matter what I call it. I have tried:

Devon

UK, Devon

Devon, UK

Devon, United Kingdom

Devon, GB

Devon, GB, United Kingdom

On Bing maps, Devon comes up absolutely fine. What is the problem please?

9 Replies
Solution

Paul, did you try Devonshire?

THANK YOU!

I was too close to the elephant there...

Hi Paul

I'm trying to do the same thing, could you give me the list of counties you're using (inc. Wales, Scotland and NI?) there is something odd with the way it recognises counties as I've  got Devon in my list and it's working fine. I'm having a problem with what on earth (no pun intended) the other options for Essex, Suffolk and Norfolk are!!

thanks

martin

Excel Map.PNG

 

Hi Martin,

 

It very depends not only on counties names, but also on how you name your column. If, for example, England, NI, etc you call Countries you have one picture. If States - another. 

 

In attached map counties you mentioned are shown. However, not sure all counties are recognized.

thank you, that's exactly what I was looking for.

@Sergei Baklan

Hi Sergie,

 

Hope you don't mind. I've attached an update to your UK Maps file correcting the data for Scotland. There are currently 32 council areas (counties) in Scotland which I have listed. There are still some errors which I think are bugs in the map chart application (see Below). 

 

Errors for Scotland
Renfrewshire, West Dunbartonshire and Midlothian are correct counties but do not show on the map.
Using the names Hebrides and Ayrshire show the areas on the map but these areas are incorrectly named.
Hebrides should be Na h-Eileanan an Iar (Gaelic for Western Isles)
Ayrshire should be South Ayrshire.

 

Hope this helps others in the community.

Thank you @Bill_Crawford , the mysteries of what Americans think our counties are called continues to amaze. MInd you, we're not the only ones.....

fox.jpg

Hi @Bill_Crawford ,

 

Thank you, I guess that will be useful for the community. I'd suggest you to send a frown to Microsoft, it's in File->Feedback

image.png

@Bill_Crawford and@Sergei Baklan thanks a lot that works great for the counties. Unfortunately only part of the level 1 regions (12 in total) are recognised. Have asked Bing to add them as provinces or states in the UK. the 12 are:

 

  • UKC. North East.
  • UKD. North West.
  • UKE. Yorkshire and the Humber.
  • UKF. East Midlands.
  • UKG. West Midlands.
  • UKH. East of England.
  • UKI. Greater London.
  • UKJ. South East.
  • Wales
  • Scotland
  • Northern Ireland
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies