Easiet Way to Create A Heat Map In Excel
Heatmaps are very handy tool to the analyze and visualize the large multi-dimensional datasets. They are often used with high-throughput gene expression data like microarray as they can help to identify hidden groups among analyzed genes or association between experimental conditions and gene expression patterns. There are several bioinformatics software to generate the heatmaps but what if you can generate heatmap without downloading any additional software or going some server. In this post I will share some tricks to generate beautiful heatmaps using your very own microsoft excel.
Click on every step to display the tutorial
I have the gene expression data for 19 genes in 4 different tissues and now I want to make heatmap of the gene expression data for all 19 genes using Microsoft excel
Select the gene expression values and go for the HOME -> CONDITIONAL FORMATTING -> COLOR SCALES -> MORE RULES
A pop-up window will open. Now go for FORMAT STYLES -> 3-COLOR SCALES You can also coustomize the coloe as per your choice
You can remove the expression values from excel cells in two ways. In first method, go for SELECT DATA -> RIGHT CLICK -> FORMAT CELLS -> CUSTOMS -> PASTE ;;; IN PLACE OF GENERAL IN TYPE MENU
You can follow this video too,
First of all, let me clear it that i am not a Bioinformatician. i am simple plant biology researcher who face problem in her daily research life and who bother to post solution of those problem on this webpage. That's it.