Home

Excel map chart - province recognized but not shown in colors

%3CLINGO-SUB%20id%3D%22lingo-sub-775065%22%20slang%3D%22en-US%22%3EExcel%20map%20chart%20-%20province%20recognized%20but%20not%20shown%20in%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775065%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20created%20a%20map%20chart%20for%20a%20one%20east%20European%20country%20Georgia%20with%20%22province%22data%20and%20it%20works%20perfectly%20with%20exception%20of%20one%20province%3A%20the%20name%20of%20the%20region%20%22Adjara%22%20is%20correct%2C%20because%20the%20Excel%20takes%20over%20its%20values%20and%20allocate%20it%20to%20the%20right%20geographical%20area.%20But%20the%20area%20is%20not%20colored%20at%20all%20like%20other%20provinces.%20I%20tried%20different%20versions%20of%20the%20name%2C%20Excel%20recognizes%202%20different%20writings%20%22Adjara%22%20and%20%22Ajara%22%20with%20the%20same%20result.%3C%2FP%3E%3CP%3EDo%20someone%20have%20a%20clue%20where%20the%20problem%20might%20be%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-775065%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775138%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20map%20chart%20-%20province%20recognized%20but%20not%20shown%20in%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775138%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382699%22%20target%3D%22_blank%22%3E%40Iris402425%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EIt's%20quite%20common%20to%20get%20issues%20with%20mapping%20when%20Data%20since%20the%20same%20State%20or%20city%20could%20be%20spelled%20in%20different%20ways.%3C%2FP%3E%3CP%3ETry%20selecting%20the%20State%20column%20and%20%26gt%3B%26gt%3B%20Data%20Tab%20%26gt%3B%26gt%3B%20Click%20Geography.%3C%2FP%3E%3CP%3EIf%20the%20State%20Spelling%20is%20different%20than%20what%20you%20have%20%26gt%3B%26gt%3B%20You%20see%20a%20Question%20mark%20to%20it'sleft%3C%2FP%3E%3CP%3EClick%20on%20the%20Question%20Mark%20%26gt%3B%26gt%3B%20Opens%20a%20pane%20on%20the%20right%20side%20%26gt%3B%26gt%3B%20Try%20a%20different%20spelling%3C%2FP%3E%3CP%3EWhen%20you%20get%20Info%20%26amp%3B%20Picture%20%26gt%3B%26gt%3B%20Hit%20Select%20to%20Replace%20current%20data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775186%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20map%20chart%20-%20province%20recognized%20but%20not%20shown%20in%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3Bhi%20Namib%2C%20thank%20you%20very%20much%20for%20this%20advice!%20I%20checked%20the%20%22Geography%22%20but%20there%20seem%20to%20be%20no%20problem%20with%20%22my%22%20regions.%20Still%20there%20is%20no%20color...%20Thanks%20anyway!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775194%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20map%20chart%20-%20province%20recognized%20but%20not%20shown%20in%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775194%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382699%22%20target%3D%22_blank%22%3E%40Iris402425%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20Problem%3C%2FP%3E%3CP%3EGood%20Luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I created a map chart for a one east European country Georgia with "province"data and it works perfectly with exception of one province: the name of the region "Adjara" is correct, because the Excel takes over its values and allocate it to the right geographical area. But the area is not colored at all like other provinces. I tried different versions of the name, Excel recognizes 2 different writings "Adjara" and "Ajara" with the same result.

Do someone have a clue where the problem might be?  

4 Replies
Highlighted

@Iris402425 

Hi

It's quite common to get issues with mapping when Data since the same State or city could be spelled in different ways.

Try selecting the State column and >> Data Tab >> Click Geography.

If the State Spelling is different than what you have >> You see a Question mark to it'sleft

Click on the Question Mark >> Opens a pane on the right side >> Try a different spelling

When you get Info & Picture >> Hit Select to Replace current data

 

hope that helps

Nabil Mourad

 

 

Highlighted

@nabilmourad hi Namib, thank you very much for this advice! I checked the "Geography" but there seem to be no problem with "my" regions. Still there is no color... Thanks anyway! 

Highlighted

@Iris402425 

No Problem

Good Luck

Nabil Mourad

Related Conversations
excel formula
loriam1225 in Excel on
1 Replies
Process the big data
yoepls in Excel on
0 Replies
Row height
yorkiebasie in Excel on
1 Replies
Load the Analysis ToolPak plugin in Excel
Daniel10 in Excel on
0 Replies
Cant understand why i cant apply formula
Kwaker in Excel on
10 Replies
Getting data from web
PeterG380 in Excel on
0 Replies