Forum Discussion
Township Areas Not Showing Up in Excel Map
It's hard to answer on such questions.
- Do we speak about built-in add-in Power Map for Excel or about Map Charts?
- About which country do we speak about? In different countries townships could be on different levels of the administrative hierarchy
- Map Charts is quite sensitive to column names; on do we use rich data types, structure tables or plain texts; on which place names and how we use.
In brief, that's only to play with concrete file, no strict rules.
Thanks SergeiBaklan. I'm talking about map charts. I'm trying to make a map of the municipalities (townships, boroughs, cities) in Pennsylvania, USA. What I don't get is after converting the data to geographic data, Excel recognizes almost all of the jurisdictions, and I can hover over them and it shows me the "card" with the jurisdiction name, county, state, population, lat/long, description, and yet they still don't show up on the map. In addition, I have neighboring jurisdictions with the exact same format and one shows up and the other doesn't. Very frustrating!
Thank you, it's more clear now.
Afraid that's nothing to do with this. Map Charts more or less works with first and second level of administration hierarchy (states and counties), at least for U.S. And practically useless with third level (townships, boroughs). However, it supports ZIP codes. I played with Adams County, Map Charts shows only few of third-level names. One of variants
For ZIP codes picture is much better
Unfortunately there is no direct mapping between townships and ZIP codes.
In behind there is no traditional database, tool works with Bing engine which search results all other the internet. Result depends on context which could be articulated directly or engine takes it analysing other data. In States you quite often have dozen places with the same name, engine shall to recognize somehow what to take.
Another point is strange, at least for me, logic used in some cases. For example, why Bing says Belgrade is located in Ottoman Empire disappeared about hundred years ago?
Anyway, I'd suggest you to send a frown from Excel in Help->Feedback->Report a problem. Attach the file, give link on this thread. Perhaps someone from Microsoft Excel team gives any comments. But in any case don't any direct feedback, they give such quite seldomly. But the are monitoring such feedbacks.
SergeiBaklan I really appreciate you diving into this. There's definitely some kooky stuff going on with the algorithm. It's really frustrating that almost all the locations are recognized but they don't appear on the map, and there's no rhyme or reason why some work and some don't. Have a great day!
