How to make a heatmap in Excel?

[Burger]

Dear All,

I would like to construct a heatmap in Excel. In other words, a figure with
two axes and each cell has a certain color based on the value for that cell
(e.g., the higher the score, the darker the color). In example of such a
figure can be found at:
http://david.abcc.ncifcrf.gov/helps/2D_Introduction_files/classification_hea
tmap.jpg

Is this possible in Excel?

Thanks in advance!

 

[Bob Phillips]

You could use the cell colour as a conditional colour, that is using the
data as the map itself..

Two problems, conditional formatting only supports 3 conditions, so you
would have to use VBA event code.

The colour palette is restricted to 56 colours, not giving the shading you
want. You could customise the colours and get the effect that you want.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)