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

Visitor

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

@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)