Excel Map does not show Bangkok

%3CLINGO-SUB%20id%3D%22lingo-sub-2131090%22%20slang%3D%22ja-JP%22%3EExcel%20Map%20does%20not%20show%20Bangkok%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131090%22%20slang%3D%22ja-JP%22%3E%3CP%3EHi%2C%20I'm%20trying%20to%20create%20a%20map%20of%20Thailand%20by%20excel%20map%3C%2FP%3E%3CP%3EBut%20the%20map%20shows%20the%20area%20of%20Bangkok%20partially.%3C%2FP%3E%3CP%3EThe%201st%20picture%20is%20how%20my%20excel%20map%20shows%20and%20the%202nd%20picture%20is%20how%20its%20shape%20supposed%20to%20be.%3C%2FP%3E%3CP%3ECan%20someone%20please%20kindly%20point%20out%20how%20can%20I%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nakada34719_0-1613200408570.png%22%20style%3D%22width%3A%20214px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254673i3A8E437543D87630%2Fimage-dimensions%2F214x170%3Fv%3D1.0%22%20width%3D%22214%22%20height%3D%22170%22%20role%3D%22button%22%20title%3D%22nakada34719_0-1613200408570.png%22%20alt%3D%22nakada34719_0-1613200408570.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nakada34719_1-1613200563241.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254674i1D85EC1F30FAAC52%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22nakada34719_1-1613200563241.png%22%20alt%3D%22nakada34719_1-1613200563241.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2131090%22%20slang%3D%22ja-JP%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2131113%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Map%20does%20not%20show%20Bangkok%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F965602%22%20target%3D%22_blank%22%3E%40nakada34719%3C%2FA%3E%26nbsp%3BContrary%20to%20what%20you%20might%20expect%2C%20using%20the%20Geography%20data%20type%20does%20not%20always%20produce%20the%20correct%20answers.%20Convert%20Bangkok%20back%20to%20text%20and%20it%20will%20work.%20See%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2131125%22%20slang%3D%22ja-JP%22%3ERe%3A%20Excel%20Map%20does%20not%20show%20Bangkok%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131125%22%20slang%3D%22ja-JP%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%20for%20replying%20to%20my%20question%3C%2FP%3E%3CP%3EActually%2C%20I%20have%20tried%20the%20same%2C%20and%20did%20not%20work%3B%20the%20map%20you%20have%20attached%20seems%20to%20show%20the%20area%20correctly%20but%20the%20area%20shows%20white%20because%20it's%20blank%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2131126%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Map%20does%20not%20show%20Bangkok%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131126%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F965602%22%20target%3D%22_blank%22%3E%40nakada34719%3C%2FA%3E%26nbsp%3BSorry.%20I%20was%20too%20anxious%20responding.%20Removing%20the%20data%20type%20will%20indeed%20merely%20remove%20Bangkok%20from%20your%20map%20leaving%20an%20empty%20space%20exactly%20for%20the%20Bangkok%20area.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20the%20picture%20below%20shows%20what%20I%20mean.%20At%20the%20top%2C%20Bangkok%20not%20data%20typed.%20At%20the%20bottom%2C%20Bangkok%20with%20data%20type.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-02-13%20at%2008.41.53.png%22%20style%3D%22width%3A%20515px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254675i21D6BF8BDCF40F72%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-13%20at%2008.41.53.png%22%20alt%3D%22Screenshot%202021-02-13%20at%2008.41.53.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I'm trying to create a map of Thailand by excel map

But the map shows the area of Bangkok partially.

The 1st picture is how my excel map shows and the 2nd picture is how its shape supposed to be.

Can someone please kindly point out how can I fix this?

 

nakada34719_0-1613200408570.png

nakada34719_1-1613200563241.png

 

 

4 Replies

@nakada34719 Contrary to what you might expect, using the Geography data type does not always produce the correct answers. Convert Bangkok back to text and it will work. See attached.

 

@Riny_van_Eekelen Thank you so much for replying to my question

Actually, I have tried the same, and did not work; the map you have attached seems to show the area correctly but the area shows white because it's blank

@nakada34719 Sorry. I was too anxious responding. Removing the data type will indeed merely remove Bangkok from your map leaving an empty space exactly for the Bangkok area.

 

But the picture below shows what I mean. At the top, Bangkok not data typed. At the bottom, Bangkok with data type.

 

Screenshot 2021-02-13 at 08.41.53.png

Thank you for your kind support

I got what you mean but when I tried the same; removing the data type in my map, the map shows it as blank. 

 And when I remove the data type from all the prefectures, then I got 3 other provinces that show blank. I have already checked its spelling and I think these are correct. I wish there is any way to solve this problem.