Geography Heat Map by County issues

%3CLINGO-SUB%20id%3D%22lingo-sub-2592886%22%20slang%3D%22en-US%22%3EGeography%20Heat%20Map%20by%20County%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2592886%22%20slang%3D%22en-US%22%3E%3CP%3Eworking%20on%20a%20Geography%20Heat%20map%20using%20temperature%20data%20for%20each%20COUNTY%20(or%20borough%20in%20Alaska%2C%20or%20parishes%20in%20Louisiana)%20in%20the%20US...99%25%20of%20the%20counties%20are%20showing%20up%2C%20but%20I%20can't%20get%20the%20following%20counties%20to%20populate%20in%20the%20heat%20map...is%20there%20a%20listing%20of%20all%20geographical%20%22county%20tags%22%20that%20Excel%20knows%20and%20will%20understand%3F%20Note%3A%20the%20Data%20-%26gt%3B%20Geography%20will%20geolocate%20these%20inputs...I%20just%20can't%20get%20them%20to%20show%20up%20in%20a%20heat%20map%20then%20and%20they%20show%20as%20blank%20spots%20as%20seen%20below...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESt%20Charles%20County%2C%20Missouri%3CBR%20%2F%3EFairfax%20County%2C%20Virginia%3CBR%20%2F%3EOrleans%20Parish%2C%20Louisiana%3CBR%20%2F%3EKusilvak%20Census%20Area%2C%20Alaska%3CBR%20%2F%3EBethel%20Census%20Area%2C%20Alaska%3CBR%20%2F%3EYakutak%20Borough%2C%20Alaska%3CBR%20%2F%3EChugach%20Census%20Area%2C%20Alaska%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%22joshgreenfield_0-1627413607819.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298777iCD3E622623EC4E37%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22joshgreenfield_0-1627413607819.png%22%20alt%3D%22joshgreenfield_0-1627413607819.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20insight%20would%20be%20great...thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2592886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2593102%22%20slang%3D%22en-US%22%3ERe%3A%20Geography%20Heat%20Map%20by%20County%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2593102%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1113991%22%20target%3D%22_blank%22%3E%40joshgreenfield%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20nothing%20predefined%20here.%20Map%20Charts%20is%20quite%20sensitive%20to%20column%20names%20and%20data%20organization%2C%20as%20well%20as%20places%20names.%20That's%20as%20with%20search%20engine%20-%20depends%20on%20wording%20in%20search%20bar%20you%20may%20find%20what%20you%20need%20very%20fast%20or%20never%20find.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20change%20data%20a%20bit%20some%20of%20your%20places%20are%20shown%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%20359px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298791iDEAB7353D56BB7E4%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%2FP%3E%0A%3CP%3EMainly%20for%20Alaska.%20On%20the%20other%20hand%20not%20all%20places%20in%20next%20level%20administrative%20divisions%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%20455px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298792iE1C565042A5108BE%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%2FP%3E%0A%3CP%3EIf%20nothing%20helps%20that's%20only%20from%20Help%20-%26gt%3B%20Feedback%20to%20send%20a%20frown%2C%20perhaps%20Microsoft%20one%20day%20checks%20bing%20engine%20algorithm%20applied%20to%20Map%20Charts%20and%20improve%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

working on a Geography Heat map using temperature data for each COUNTY (or borough in Alaska, or parishes in Louisiana) in the US...99% of the counties are showing up, but I can't get the following counties to populate in the heat map...is there a listing of all geographical "county tags" that Excel knows and will understand? Note: the Data -> Geography will geolocate these inputs...I just can't get them to show up in a heat map then and they show as blank spots as seen below...

 

St Charles County, Missouri
Fairfax County, Virginia
Orleans Parish, Louisiana
Kusilvak Census Area, Alaska
Bethel Census Area, Alaska
Yakutak Borough, Alaska
Chugach Census Area, Alaska

 

joshgreenfield_0-1627413607819.png

 

any insight would be great...thanks!

 

5 Replies

@joshgreenfield 

That's nothing predefined here. Map Charts is quite sensitive to column names and data organization, as well as places names. That's as with search engine - depends on wording in search bar you may find what you need very fast or never find. 

If change data a bit some of your places are shown

image.png

Mainly for Alaska. On the other hand not all places in next level administrative divisions

image.png

If nothing helps that's only from Help -> Feedback to send a frown, perhaps Microsoft one day checks bing engine algorithm applied to Map Charts and improve it.

thanks @Sergei Baklan!  I was able to get the Alaska boroughs to show up at the state level...however if you change the map chart to the county level (series values =Sheet1!$E$7:$E$13), then it won't map at the county level for a few of the counties...I think Microsoft might need to update some geotags in their map county map chart as the below counties with a purple highlight should have data per the data table.

 

joshgreenfield_0-1627433535392.png

 

@Sergei Baklan ...another quick question, but on a similar subject...when I transfer a file with a large quantity of already geo-tagged cells (about 3000 US counties), the user I send the file to only sees #UNKNOWN in those cells, even though they have the correct version of Excel and should be able to open it just fine. is the geotag data linked to a supplemental file on my computer or something??

 

joshgreenfield_0-1627479003275.png

 

@joshgreenfield 

To my knowledge everything is done on the server, Excel only keeps in cache within current file results of the latest update (refresh). If next update fails for any reason you have an error.

Perhaps that could be due to different locale, e.g. you are on English US and another person on Spanish one.

Here similar issue was discussed, unfortunately without solution Geography data with #UNKNOWN! error - Microsoft Community

 

Sorry, but I don't know exact answer.

thanks Sergei for the link to that other post...that is the exact issue I am having...transferring files with a few geotags works fine, but many (3000+ for me) does not work and shows #UNKNOWN.