Excel Geography fails to recognize state county... Denver County, Colorado ...

Question

Every time I go and try to get excel geo to update the state of Colorado counties although I have provided the county names, the system will not recognize Denver as a county and therefore, will not map correctly the data I have in another column. When I enter Denver County, Colorado it continually returns the following. Any idea?Delta County, ColoradoColoradoDenverColorado

sergeibaklan · Answer

rsvalleroy&nbsp;
Could you please to give bit more details what exactly you do. Lot of options for Denver and you may force any of it

rsvalleroy · Answer

SergeiBaklan&nbsp;Certainly, I have a spreadsheet I am using with data sets for 28 states including enrollment information by county in these states. The only state where this is occurring is in Colorado. Below is the entire subset of counties in CO which the system correctly identified. While Bloomfield and Denver are cities and counties I tested other states such as Texas where Dallas is a city and county and it correctly displayed Dallas county, I will show that below as well.&nbsp; I am unable to accurately use the MAP function since it will not recognize Denver County or Broomfield County; therefore they will not display.&nbsp;CountyStateOrganization NameOrganization TypeEnrolledAdams County, ColoradoColoradoHealth and LifeLocal CCP503Arapahoe County, ColoradoColorado&nbsp;Health and LifeLocal CCP558Boulder County, ColoradoColorado&nbsp;Health and LifeLocal CCP207Clear Creek County, ColoradoColorado&nbsp;Health and LifeLocal CCP15Delta County, ColoradoColorado&nbsp;Health and LifeLocal CCP16DenverColorado&nbsp;Health and LifeLocal CCP544Douglas County, ColoradoColorado&nbsp;Health and LifeLocal CCP163El Paso County, ColoradoColorado&nbsp;Health and LifeLocal CCP520Fremont County, ColoradoColorado&nbsp;Health and LifeLocal CCP50Jefferson County, ColoradoColorado&nbsp;Health and LifeLocal CCP473La Plata County, ColoradoColorado&nbsp;Health and LifeLocal CCP26Larimer County, ColoradoColorado&nbsp;Health and LifeLocal CCP417Mesa County, ColoradoColorado&nbsp;Health and LifeLocal CCP57Montezuma County, ColoradoColorado&nbsp;Health and LifeLocal CCP94Pueblo County, ColoradoColorado&nbsp;Health and LifeLocal CCP162Teller County, ColoradoColorado&nbsp;Health and LifeLocal CCP35Weld County, ColoradoColorado&nbsp;Health and LifeLocal CCP569Broomfield, ColoradoColorado&nbsp;Health and LifeLocal CCP51&nbsp;Texas&nbsp; below:CountyStateOrganization NameOrganization TypeEnrolledAngelina County, TexasTexasHealth and LifeLocal CCP215Aransas County, TexasTexasHealth and LifeLocal CCP12Atascosa County, TexasTexasHealth and LifeLocal CCP11Bandera County, TexasTexasHealth and LifeLocal CCP12Bexar County, TexasTexasHealth and LifeLocal CCP208Brazoria County, TexasTexasHealth and LifeLocal CCP242Cameron County, TexasTexasHealth and LifeLocal CCP272Collin County, TexasTexasHealth and LifeLocal CCP151Dallas County, TexasTexasHealth and LifeLocal CCP431Denton County, TexasTexasHealth and LifeLocal CCP244

sergeibaklan · Answer

rsvalleroy&nbsp;
If to play a bit with columns and names they are shown both

Please check in attached file

rsvalleroy · Answer

I am sorry, I dont know what you mean by "play a bit with columns and names" I have tried doing that and without the geography accurately applying Denver County, Colorado it does not map and will not show the results i need from last column. I am also seeing the same thing in other states where a county is also a city.. This seems to be an issue between Bing and the Geomapping in excel and its quite an issue for us.Can you further explain what you mean by playing with columns? I can even try selecting from the Data section Denver Colorado and it still fails to map correctly. I was able to create the map you showed above except it does not propagate the data from the column correctly. I appreciate your help with this but this seems like a bigger issue than playing with columns.

sergeibaklan · Answer

rsvalleroy&nbsp;
Tool is quite sensitive to column names, value names, formatting (do we use plain text, structured table or/and rich data types).
For example , with the sample, if use both columns State and County, or only one column County, result will be different.
Did you open the file attached to my previous post? On my computer it shows counties correctly, I attached slightly modified file again.
&nbsp;
Map Charts in Excel uses Bing services. In theory results for the same query shall be the same in Charts and on maps.bing.com. On practice not necessary. How data from our Excel file is transformed on Microsoft servers to call bing services in which form it returns back - it's not the same as we query maps in browser.

Forum Discussion

Excel Geography fails to recognize state county... Denver County, Colorado ...

Share

Resources

County	State	Organization Name	Organization Type	Enrolled
Adams County, Colorado	Colorado	Health and Life	Local CCP	503
Arapahoe County, Colorado	Colorado	Health and Life	Local CCP	558
Boulder County, Colorado	Colorado	Health and Life	Local CCP	207
Clear Creek County, Colorado	Colorado	Health and Life	Local CCP	15
Delta County, Colorado	Colorado	Health and Life	Local CCP	16
Denver	Colorado	Health and Life	Local CCP	544
Douglas County, Colorado	Colorado	Health and Life	Local CCP	163
El Paso County, Colorado	Colorado	Health and Life	Local CCP	520
Fremont County, Colorado	Colorado	Health and Life	Local CCP	50
Jefferson County, Colorado	Colorado	Health and Life	Local CCP	473
La Plata County, Colorado	Colorado	Health and Life	Local CCP	26
Larimer County, Colorado	Colorado	Health and Life	Local CCP	417
Mesa County, Colorado	Colorado	Health and Life	Local CCP	57
Montezuma County, Colorado	Colorado	Health and Life	Local CCP	94
Pueblo County, Colorado	Colorado	Health and Life	Local CCP	162
Teller County, Colorado	Colorado	Health and Life	Local CCP	35
Weld County, Colorado	Colorado	Health and Life	Local CCP	569
Broomfield, Colorado	Colorado	Health and Life	Local CCP	51