Forum Discussion
Excel Geography fails to recognize state county... Denver County, Colorado ...
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. I am unable to accurately use the MAP function since it will not recognize Denver County or Broomfield County; therefore they will not display.
| 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 |
Texas below:
| County | State | Organization Name | Organization Type | Enrolled |
| Angelina County, Texas | Texas | Health and Life | Local CCP | 215 |
| Aransas County, Texas | Texas | Health and Life | Local CCP | 12 |
| Atascosa County, Texas | Texas | Health and Life | Local CCP | 11 |
| Bandera County, Texas | Texas | Health and Life | Local CCP | 12 |
| Bexar County, Texas | Texas | Health and Life | Local CCP | 208 |
| Brazoria County, Texas | Texas | Health and Life | Local CCP | 242 |
| Cameron County, Texas | Texas | Health and Life | Local CCP | 272 |
| Collin County, Texas | Texas | Health and Life | Local CCP | 151 |
| Dallas County, Texas | Texas | Health and Life | Local CCP | 431 |
| Denton County, Texas | Texas | Health and Life | Local CCP | 244 |
If to play a bit with columns and names they are shown both
Please check in attached file
- 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.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.
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.