 # Get instant live expert help on I need help with excel heat map “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I am trying to create a heat map using x y coordinates and having trouble
Solved by X. J. in 30 mins
Need an excel expert to create a geographical heat map with keys showing the relationship between Acoounts conversion grade (column P) and their State (column Q). NB. Map Add-in is probably required.
Solved by I. U. in 18 mins
Is there any way to view the ratio of variable/color differentiation while using a heat map in excel power maps? Also, is there any way to view a total number of variables within each heat signature? The ratio (example red =50+ occurrences) would be most appreciated. Thanks!
Solved by S. J. in 24 mins
I have two column one with names, second with # of times we met with them. I want to create a heat map but the colors show up in the names using their corresponding #s it's that possible?
Solved by O. W. in 26 mins
Need a IF formula to drag down for a Heat Map bubble chart B2&C2=3or-3= 3, B2&C2=(-)2&(-)3 = 2.5, B2&C2=2or-2= 2, B2&C2=(-)1or(-)2= 1.5, B2&C2=1or-1= 1 B2&C2=0or(-)0= 0.5
Solved by F. E. in 11 mins