|
Heatmap Tool (VBA)
I developed this tool while working at Harvard Institutes of Medicine, in order to visualize the expression leves of genes on DNA microarrays. It is an MS Excel macro that takes a table of numbers and turns it into a colored heatmap, where the brightness/hue is proportional to the size of the number. For example:
The .bas file can be downloaded free of charge by clicking here.
Please not that this is not a distribution version and comes without warranty etc. It is intended for those familiar with Excel macros, not those who have no Excel experience. However, the following instructions should be enough to get most people started:
Download the .bas macro above, and the sample Excel spreadsheet here.
The sample spreadsheet is just an example. All that matters is that the data that will generate the heatmap be contiguous, i.e. no gaps.
Go to the Visual Basic Editor, e.g. by hitting Alt+F11
Import the macro into the VBEditor using File->Import File... and then select the file heatmap.bas which you just downloaded.
Run the macro on your data, either (a) within the VBEditor (hit F5), (b) from the spreadsheet itself. The second option is probably easiest: Close the VBEditor, then place the cursor inside the data, then hit Alt+F8 (or go Tools->Macro->Macros...).
NB: There are a few different versions of the macro, which produce slightly different results. Some of the macros normalize by row (i.e. each row will have a very bright cell and a very dull cell), some by column, some exclude outliers, etc. Pick whichever suits your needs
The code is commented, and should be fairly easy to modify
I would really appreciate it if you would email me
to tell me how you're using the macros. Also, if you modify the code, send me a copy - I'd be interested in seeing the changes. You can also contact me with questions or comments.
 |
 |
Posted by senorjosh at April 24, 2003 01:57 AM
Can you kindly send me a sample text or excel file to be loaded to generate the heatmap.I have Affymetrix microarray data and was wondering if I could use it to generate heatmaps
Thanks
Srinivas
Posted by: Srinivas at November 7, 2003 01:52 PM
Can you kindly send me a sample text or excel file to be loaded to generate the heatmap
Posted by: Aiyaz at January 5, 2004 12:04 PM
I've updated this page to include a link to the relevant Excel spreadsheet. Let me know if you still have questions.
Posted by: josh at January 9, 2004 03:05 PM
How can we implement this tool on Mac's??
Posted by: at January 25, 2004 09:02 PM
Rishi - unfortunately, I have no idea how to get the macros running on a mac, unless you have Excel installed (with Excel, everything should work as described). alternatively, you could open the file in a text editor to see the code, which is pretty self-explanatory, and then convert it into a language you´re familiar with. Sorry I can´t be of more help. Drop me a line when you find a work-around.
Posted by: josh at January 26, 2004 05:14 PM
|
|
