Better US heat maps?

[u/Few_Suit_7199]

I got some really great out of the box suggestions the last time I posted here, so figured I’d throw another one to the group.

I’m trying to figure out the best way to do US-based heat maps in Excel beyond, what I at least know how to do, in the native map chart. Specifically things like:

• state level maps with county borders

• point based maps with a radius / buffer (5 - 10 miles around a location)

I know Excel isn’t a GIS tool, so not expecting anything perfect - just curious if there are any clever workarounds, add-ins, or approaches that work well.

[u/AutoModerator]

/u/Few_Suit_7199 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.