In this video we will learn how to draw a heat map.
Heat Map is not a graph.
It is not a chart.
It is just formatting the data table so that you can quickly identify the pattern in that data.
They will
as you can see in this data the same data that we used to create this first chart.
So on the left we have these seven days Monday Tuesday.
So on to the sun and on top.
We have intervals of the words for that particular day.
And this data is giving me the number of customers visiting our website.
In that two hour interval.
So on a Monday between 2 a.m. to 2 a.m. I get 494 customers on my website so each cell is representing
the number of customers visiting on that particular day.
In a two hour interval on our website.
So if I just give you this table without any formatting it will be difficult to find out at which point
of time India will be.
You are getting more number of customers and which part of the week there are fewer customers on our
website.
This is where the heat map will help us heat map will highlight different value ranges with different
colors for example.
You can see a spectrum here.
The lowest values in this table are in green color dark green.
Slowly the darkness is decreasing and you see larger values of colors.
Then it becomes yellow where you have medium values.
Then it becomes slowly to red where you have the highest value to this spectrum is covering largest
to smallest value.
And it is easy to identify that you are getting most number of customers on a Sunday or a Saturday in
the 10 a.m. to 2 p.m. timespan and you are getting minimum customers on a Monday or Tuesday at the.
That is 10 p.m. to 14.
So let us learn how to create this heat map
so here's that data with no formatting.
We will select these cells which contain the numbers.
We will go to home and this conditional formatting option.
Here you can see we have a number of options to draw a heat map.
We will use the color skills option and we can choose different types of color scales you can hold over
these options to select the color scale or the spectrum of colors that you want and select the second
one.
You can also customize these colors by going to the more rules option inside this conditional formatting.
You can click on this to select the starting color and the end singular and give the spectrum that to
know more about what all automatic options we have in excel.
You can add effort to another course the Excel master class scores which is a four hour course and it
will tell you all the formatting techniques that you can use in Microsoft Excel.
Also if you just want to pick colors and not sure this numerical value in individual cells you can remove
these numerical values by selecting this data right click on it go do what matters here.
We will give it custom formatting to this and the formatting is semicolon semicolon semicolon.
This means that whatever number is here it should be hidden.
Click on Okay all those numbers at it and you just have a heat map telling you where the values are
large and where the small as you can see this chart is also giving us all the information that the surface
star gives.
So the heat map is a very good substitute for surface chart whenever you want to display the values
or the pattern in your data table.
Instead of drawing the surface jar it is always preferable to use a heat map.