I would like to make a heat map using the Excel data below with 3 objectives in order of priority:

1) heat map of customers

2) Also map the location of the sales branch

3) Shade the regions (if possible)

If you could at least point me in the right direction of the software I could use, that would be helpful as well.

Thanks in advance.

Sold-to party - Key	Cust. City	Cust. State	Branch (Sls Office)	Region
10000003	HUNTINGTON BEACH	CA	Southern California	Western
10000004	FORT WORTH	TX	Southern California	Western
10000005	FORT WORTH	TX	Southern California	Western
10000014	SPRINGFIELD	VA	National Sales	FALSE
10000014	SPRINGFIELD	VA	Corporate Sales	FALSE
10000014	SPRINGFIELD	VA	CSS US	FALSE
10000015	GLEN ELLYN	IL	Chicago	Eastern
10000018	DANVERS	MA	New England	Northeast
10000019	ROCKY HILL	CT	New England	Northeast
10000028	GREENVILLE	SC	Greenville	Eastern
10000033	EAST BRUNSWICK	NJ	New York Metro	Northeast
10000039	SALT LAKE CITY	UT	Salt Lake City	Western
10000054	CEDAR RAPIDS	IA	Cedar Rapids	Central
10000057	PORTLAND	OR	Portland	Western
10000060	HUMBLE	TX	Houston	Central
10000062	BROOKFIELD	WI	Milwaukee	Eastern
10000064	ROCHESTER	NY	Rochester	Northeast
10000066	MOORESTOWN	NJ	Philadelphia	Northeast
10000067	KENT	WA	Seattle	Western