Forum Discussion

ExcelUser222's avatar
ExcelUser222
Copper Contributor
Mar 16, 2022

Township Areas Not Showing Up in Excel Map

I am having trouble with the excel mapmaking tool. When I try to create a township map for my county, four of my nineteen townships do not show up in the map. When I try to map these four townships individually, they do not show up. They all have a data point greater than zero attached to them, so they should be appearing in the map but I can't figure out why these townships aren't loading into my map. They are the correct townships as well, when I click on their names for more information they are appearing in the correct county. Any help would be greatly appreciated!

    • SergeiBaklan's avatar
      SergeiBaklan
      MVP

      MichaelT1855 

      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.

      • MichaelT1855's avatar
        MichaelT1855
        Copper Contributor

        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!

Resources