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.
As you can see in this data, the same data that we used to create this address chart, so on the left
we have this seven days, Monday, Tuesday, so on till Sunday, and on top, we have intervals of two
hours 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 12 a.m. to do when I get all 94 customers on my Web site.
Ethan 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 in the whole week 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 the stable orange, green color, dark
green, slowly the darkness is decreasing and you see larger values of colors.
Then it becomes yellow where you have median values.
Then it becomes slowly to red where you have the highest value.
So this spectrum is governing largest to smallest value, and it is easy to identify that you're getting
most number of customers on a Sunday, on a Saturday, in the 10 a.m. to two p.m. time span.
And you are getting minimum customers on a Monday or Tuesday at night time.
That is 10 p.m. to 14.
So let us learn how to create this heightmap.
So here's the data with no formatting.
We will select these words 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 here.
We can choose different types of color scales.
You can hover over these options to select the colors of the spectrum of colors that you want.
I inflicted the second one.
You can also customize these colors by going to the more rules option inside this condition formatting.
You can click on this to select the starting color and the ending color and give this pattern there.
To know more about what formatting options we have in Excel, you can Referer Anadarko's the Excel Masterclass
course, which is a four hour course and it will tell you all the formatting techniques that you can
use in Microsoft.
And also if you just want to keep the colors and nor should this numerical value in individual cells,
you can remove these numerical values by selecting this data.
Right.
Click on it.
Go to formatters.
We will give a custom formatting to this and the formatting is semicolon, semicolon, semicolon.
This means that whatever number is here should be hidden.
Click on, OK, all those numbers are written.
You just have a heat map telling you where the values are large and where they are small.
As you can see, this chart is also giving us all the information that Richard 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 trying to solve
which, it is always preferable to use a heat map.