Heat Maps in Excel

[Statistician]

Does anyone know how to create heat maps in excel?

The kind I'm looking at are like those shown in the following link:

http://www.digitallook.com/cgi-bin/dlmedia/investing/visual_tools/market_maps?&username=&ac=

I want to be able to change the size and colour of the boxes

 

[N1GHTEYES]

Create them manually?
Using conditional formatting?
Using VBA to assign colours?

Give us a clue. Say exactly what data you have and how you want to display it and somebody might be able to help.

By the way, not everybody can follow the link you included because the usage rules at work prohibit it. So please be explicit - do not just refer to the link.

Tony

 

[Statistician]

N1GHTEYES

Apologies for lack of detail.

I've subsequently found out that I was actually after something called TreeMaps not heat maps. These are available as an addin into Excel and do exactly what I wanted.

I will certainly take on board your advice next time I ask for assistance. Cheers.