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
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi ssusin,

 

Based on my test, if we set Location based on Zip code, when change visualization as Stacked Column, ZIP codes 10024 and 10014 can also display in Excel 3D maps . See:

 

 

In your scenario, how did you specify the Location? You can download attached Excel to have a look. If issue persists, would you please share your Excel file for our analysis?

 

Best Regards,
Qiuyun Yu

ssusin's avatar
ssusin
Regular Visitor
9 years ago

Qiuyun,

 

Thanks for getting back to me.

 

I opened your example (zip codes.xlsx), and confirmed that I can see a column on the map for ZIP code 10024. However, when I click on "change the visualization to region", all the ZIP codes are shaded in except for 10024. This is the problem I am having too.

 

I've put together an example that shows that the problem occurs in less artificial circumstances, but I don't seem to be able to upload attachments to this forum.  In any event, your example illustrates the problem pretty well.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi ssusin,

     

    I already reported this issue internally, will keep you updated once get any feedback.

     

    Best Regards,
    Qiuyun Yu

    • OfficeMgr615's avatar
      OfficeMgr615
      New Member
      9 years ago

      Im having the same issue but with zip codes right here in the USA. Specifically 22556 Stafford Virgina, 53142 Kenosha and 53403 Racine Wisconsin. I want to see the Visualization by Region. When I have this set by County the whole area is colored, but as you can see from the picture, when it goes to zip codes I have holes in my map. I've tried deleteing and re-adding the data, doesnt help. HELP has this been fixed yet?!?!

       

      Stafford County in VA22556 missing zip code

    • mcruz625's avatar
      mcruz625
      New Member
      8 years ago

      Have there been any updates to this issue?  Not sure how to explain to my folks that some zip codes in Georgia just won't show up in their maps!