How to Create a "Heat MAp" with city & State

[Jkm_TRYING]

Hello All.

Thanks for your help.  I am sure this will be simple to solve for most. 

I have a list of customers and I would like to visualize the data on a US map somehow sorted by number of customers per state.  How should I create a heat map to see where most of my customers are and are not?  Or something useful along these lines???

Most grateful  for any ideas or tips.  Thank you.

[#2]

@Jkm_TRYING 

A Heat Map in Excel is a visual representation that quickly shows you a comparative view of a dataset.

How to Create a Heat Map in Excel – A Step By Step Guide

or....

How to Make a Dynamic Geographic Heat Map in Excel

Standard Disclaimer: These are links to non-Microsoft websites.

 Hope I was able to help you with this links.

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)