Rich, I'm also seeing an entire world map with no values in the map. My zip codes are only in Minnesota, so I'm not sure why these zip codes don't auto generate a map of Minnesota like yours did for FL. Any ideas?
I've got Office 365, which has the home/student version of Excel (2016) and doesn't have the map feature (amongst other features). is there an add-in I can purchase that will add these map features?
I don't think Microsoft sells this specific feature as a separate add-in. They are lots of enterprise grade tools like Power Bai & Tableau which offer mapping. I would probably just upgrade to a standard version of Office 365.
this isn't working for me. Excel is not seeing my zip codes and making a chart. "Map charts work best with geographical data such as state/province and country/region in separate columns. Check your data and try again."
That's a nasty cough man! Hope you didn't have Covid. Next time mute that out or record without the nasty coughing throughout. Makes for a much more professional presentation
![How to Make a US Heat Map in Excel with Zip Code Lists! 🗺️[Lesson 9 of 11]](http://i.ytimg.com/vi/Ns96DIhyCSQ/mqdefault.jpg)
I usually don't comment on videos, but THANK YOU! This was JUST the tutorial I needed--simple, easy to follow, no BS. I truly appreciate you!!!
Thank you so much for the feedback! I’m glad you found it useful. I hope you will subscribe and continue to check us out!
This is legend. Exactly what I needed. THANK YOU!
Thank you Andy! I'm glad you found it useful!
Freaking game changer - did not know this was a thing. 100% subscribing for more excel content!
Thank you so much for subscribing! If you have any requests, please let me know!
this solves the 'Bing Hawaii map bug'...shows the major islands very small in the bottom right corner ...thanks!
Rich, I'm also seeing an entire world map with no values in the map. My zip codes are only in Minnesota, so I'm not sure why these zip codes don't auto generate a map of Minnesota like yours did for FL. Any ideas?
Hey Andrew! Are you using only 5 digits or zip plus 4 as well? If you try with only a few records from your list, does it work?
This is incredible!!!
My chart stays zoomed out on the whole world and not within the boundary that would allow for the zip codes to show clearly 😮
Hey David, what area of the world are you mapping? How far apart are the different areas?
⁶⁷208
incredible. Thank you.
Thank you too! @danielhudspeth5699
This is a great explanation! Is there a way to see freeways, roads, etc.?
Yes. Do 3d map instead
I've got Office 365, which has the home/student version of Excel (2016) and doesn't have the map feature (amongst other features). is there an add-in I can purchase that will add these map features?
I don't think Microsoft sells this specific feature as a separate add-in. They are lots of enterprise grade tools like Power Bai & Tableau which offer mapping. I would probably just upgrade to a standard version of Office 365.
What version of excel is required? I have 2016.
Hey Luke... It should be in there... not in the charts section? It's a chart called filled map. Run an update if you're not seeing it ...
When I change the projection it still shows the whole state.
this isn't working for me. Excel is not seeing my zip codes and making a chart. "Map charts work best with geographical data such as state/province and country/region in separate columns. Check your data and try again."
I get the same thing.
Hey Jay! If you want to send me a sample of your spreadsheet, I'll take a look at it for you...
Hey Elena! If you want to send me a sample of your spreadsheet, I'll take a look at it for you...
richkerr@richkerr.com
richkerr@richkerr.com
That's a nasty cough man! Hope you didn't have Covid. Next time mute that out or record without the nasty coughing throughout. Makes for a much more professional presentation
Thanks Hunter. No Covid, just a cold. I think I will re-do this one after taking a Halls. :-)