1 00:00:01,540 --> 00:00:08,660 In this video, we will learn how to draw a heat map, heat map is not a graph. 2 00:00:08,740 --> 00:00:09,680 It is not a chart. 3 00:00:11,260 --> 00:00:19,060 It is just formatting the data table so that you can quickly identify the pattern in that data. 4 00:00:22,410 --> 00:00:32,190 As you can see in this data, the same data that we used to create this address chart, so on the left 5 00:00:32,190 --> 00:00:41,060 we have this seven days, Monday, Tuesday, so on till Sunday, and on top, we have intervals of two 6 00:00:41,070 --> 00:00:42,740 hours for that particular day. 7 00:00:43,740 --> 00:00:49,740 And this data is giving me the number of customers visiting our website in that two hour interval. 8 00:00:50,700 --> 00:00:57,570 So on a Monday between 12 a.m. to do when I get all 94 customers on my Web site. 9 00:01:00,990 --> 00:01:07,890 Ethan is representing the number of customers visiting on that particular day in a two hour interval 10 00:01:08,250 --> 00:01:09,090 on our website. 11 00:01:11,130 --> 00:01:18,000 So if I just give you this table without any formatting, it will be difficult to find out at which 12 00:01:18,000 --> 00:01:23,520 point of time in the whole week you are getting more number of customers and which part of the week 13 00:01:24,180 --> 00:01:25,920 there are fewer customers on our website. 14 00:01:27,420 --> 00:01:29,490 This is where the heat map will help us. 15 00:01:29,670 --> 00:01:35,070 Heat map will highlight different value ranges with different colors. 16 00:01:37,470 --> 00:01:45,800 For example, you can see a spectrum here, the lowest values in the stable orange, green color, dark 17 00:01:45,810 --> 00:01:52,640 green, slowly the darkness is decreasing and you see larger values of colors. 18 00:01:53,430 --> 00:01:56,550 Then it becomes yellow where you have median values. 19 00:01:57,210 --> 00:02:00,870 Then it becomes slowly to red where you have the highest value. 20 00:02:02,600 --> 00:02:09,710 So this spectrum is governing largest to smallest value, and it is easy to identify that you're getting 21 00:02:09,710 --> 00:02:18,460 most number of customers on a Sunday, on a Saturday, in the 10 a.m. to two p.m. time span. 22 00:02:19,670 --> 00:02:25,580 And you are getting minimum customers on a Monday or Tuesday at night time. 23 00:02:25,590 --> 00:02:27,690 That is 10 p.m. to 14. 24 00:02:29,780 --> 00:02:32,570 So let us learn how to create this heightmap. 25 00:02:35,830 --> 00:02:38,480 So here's the data with no formatting. 26 00:02:39,580 --> 00:02:41,850 We will select these words which contain the numbers. 27 00:02:44,140 --> 00:02:52,270 We will go to home and this conditional formatting option here, you can see we have a number of options 28 00:02:53,740 --> 00:02:54,910 to draw a heat map. 29 00:02:55,190 --> 00:02:58,420 We will use the color skills option here. 30 00:02:59,170 --> 00:03:01,720 We can choose different types of color scales. 31 00:03:04,030 --> 00:03:10,330 You can hover over these options to select the colors of the spectrum of colors that you want. 32 00:03:12,240 --> 00:03:13,610 I inflicted the second one. 33 00:03:14,350 --> 00:03:20,380 You can also customize these colors by going to the more rules option inside this condition formatting. 34 00:03:21,980 --> 00:03:30,260 You can click on this to select the starting color and the ending color and give this pattern there. 35 00:03:32,610 --> 00:03:40,140 To know more about what formatting options we have in Excel, you can Referer Anadarko's the Excel Masterclass 36 00:03:40,140 --> 00:03:44,820 course, which is a four hour course and it will tell you all the formatting techniques that you can 37 00:03:44,820 --> 00:03:46,260 use in Microsoft. 38 00:03:46,450 --> 00:03:56,040 And also if you just want to keep the colors and nor should this numerical value in individual cells, 39 00:03:56,550 --> 00:04:00,390 you can remove these numerical values by selecting this data. 40 00:04:00,960 --> 00:04:01,260 Right. 41 00:04:01,260 --> 00:04:01,800 Click on it. 42 00:04:02,640 --> 00:04:03,840 Go to formatters. 43 00:04:06,210 --> 00:04:14,350 We will give a custom formatting to this and the formatting is semicolon, semicolon, semicolon. 44 00:04:15,120 --> 00:04:18,350 This means that whatever number is here should be hidden. 45 00:04:19,180 --> 00:04:21,420 Click on, OK, all those numbers are written. 46 00:04:21,690 --> 00:04:27,450 You just have a heat map telling you where the values are large and where they are small. 47 00:04:29,600 --> 00:04:37,080 As you can see, this chart is also giving us all the information that Richard gives, so the heat map 48 00:04:37,080 --> 00:04:39,990 is a very good substitute for surface chart. 49 00:04:40,950 --> 00:04:46,080 Whenever you want to display the values or the pattern in your data table, instead of trying to solve 50 00:04:46,100 --> 00:04:49,440 which, it is always preferable to use a heat map.