Forum Discussion

ssusin's avatar
ssusin
Regular Visitor
9 years ago

Missing ZIP Codes in Excel 3D Maps

In Excel 2016 3D maps, certain New York City ZIP codes are missing. Two examples are ZIP codes 10024 and 10014. That is, when I try to get these regions outlined, they appear blank, while most ZIP co...
Need Help
dh5237's avatar
dh5237
New Member
9 years ago

I'm having a problem with 3D Maps not finding a resolution for a set of several zip codes mainly the problem is with Zip Code with Leading Zero's  in Puerto Rico and the US Virgin Islands.  I 'm currently working on get the Lat and Lon data for my entire data set to hopefully eliminate the problem global . Overall I had a 95% Mapping Confidence for 13,051 unquie zip codes.  Any insights would be appreciated. 

Examples:

00603;00612;00659;00674;00680;00682;00692;00693;00694;00698;00716;00725;00729;00731;00732;00736;00738;00740;00757;00778;00784;00791;00802;00820;00840;00901;00907;00912;00917;00918;00926;00949;00957;00961;00962;00965;00966;00968;00976;00979;00982;00983;00987

 

 

  • Juppu's avatar
    Juppu
    Regular Visitor
    9 years ago

    Have you tried to format the zipcodes as text in the excel-sheet? it worked for me :) 

    • OfficeMgr615's avatar
      OfficeMgr615
      New Member
      9 years ago

      Still doesnt fill in the missing zip codes as they were already set to text. There are just some zip codes that dont populate.

      Excel 3D Maps also has a problem misplacing zip codes over other zip codes and labeling them wrong.

       

      Program has been too "broken" for our business to use. We just can't rely on it, we've already switched to a different map program that works a million times better.

      • Juppu's avatar
        Juppu
        Regular Visitor
        9 years ago

        What program are you using? :)