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


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.

1 Reply


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


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



I know I don't know anything (Socrates)