1 00:00:01,890 --> 00:00:09,340 In this video we will learn how to create a sophisticated sophisticated display two or more data cities 2 00:00:09,430 --> 00:00:14,700 on a surface these charts can be very interesting. 3 00:00:15,230 --> 00:00:18,950 But in most of the business settings these are not used 4 00:00:21,750 --> 00:00:23,790 just like an online Jack. 5 00:00:24,150 --> 00:00:31,790 We have one category access that was the x axis and the corresponding values was shown on the y axis. 6 00:00:32,110 --> 00:00:40,080 In a surface chart we have two category axis and a value corresponding to a combination of these categories 7 00:00:40,830 --> 00:00:43,890 is plotted on a surface. 8 00:00:44,160 --> 00:00:54,130 As an example I have this data of how many users are visiting my website every two hours of the day. 9 00:00:55,830 --> 00:01:05,040 So for example on a Monday between 3 to 2 a.m. 494 customers are visiting my website. 10 00:01:05,340 --> 00:01:13,170 Between 2 to 4 a.m. 789 customers are visiting between four to six thousand customers are visiting and 11 00:01:13,170 --> 00:01:14,240 so on. 12 00:01:14,590 --> 00:01:21,370 And this data is available for seven days so I have two categories. 13 00:01:21,370 --> 00:01:30,190 One is these days and one is the two hour slot and these are the values of customers. 14 00:01:30,220 --> 00:01:34,420 Thus I will plot on the y axis these two categories. 15 00:01:34,420 --> 00:01:44,440 I'll plot on these two separate axes so the values on these two separate axes will give me a surface. 16 00:01:44,850 --> 00:01:48,700 So in this graph if you see my here. 17 00:01:49,270 --> 00:01:56,230 So this particular line this first line of this surface is for Monday. 18 00:01:56,440 --> 00:02:03,060 That is this value zero point 4 9 4 will be this value. 19 00:02:03,060 --> 00:02:06,450 This corner point then it keeps on increasing. 20 00:02:06,640 --> 00:02:08,330 Two point seven eight nine. 21 00:02:08,470 --> 00:02:11,150 Then do one thousand fifty eight. 22 00:02:11,770 --> 00:02:13,050 To this highest point. 23 00:02:13,180 --> 00:02:22,480 And then again start going down the next day which is Tuesday comes a little further and it goes up 24 00:02:22,480 --> 00:02:23,490 to Sunday. 25 00:02:23,500 --> 00:02:25,860 This last point is what Sunday. 26 00:02:27,680 --> 00:02:33,840 And as you can see this graph has different colors over the surface. 27 00:02:34,750 --> 00:02:39,520 So these colors represent the same value range. 28 00:02:39,520 --> 00:02:53,290 So on this part of the surface the number of visitors are see that is on a Sunday at twelve AM. 29 00:02:53,410 --> 00:03:00,430 The number of visitors that I have is similar to number of listed that I have honor Tuesday at nearly 30 00:03:00,460 --> 00:03:02,500 12 p.m.. 31 00:03:02,860 --> 00:03:09,180 So this whole part of the service represents our same value date. 32 00:03:11,290 --> 00:03:15,610 So now let us learn how to create a surplus chart. 33 00:03:15,610 --> 00:03:16,740 I believe this chart 34 00:03:22,170 --> 00:03:27,730 will select the data go to insert go to surface chart options 35 00:03:30,440 --> 00:03:32,220 and I to take this first option 36 00:03:36,530 --> 00:03:37,030 again. 37 00:03:37,130 --> 00:03:45,470 If the selected axis is not as but your equipment you can always go to selected option and use these 38 00:03:45,530 --> 00:03:47,380 data cities that you want. 39 00:03:49,950 --> 00:03:52,770 There are other types of surface chart. 40 00:03:52,770 --> 00:03:57,410 If you go to the gym duct tape you can see the second type is a wireframe chart. 41 00:03:57,490 --> 00:04:02,330 So instead of a sad face you'll get a wireframe and the intersection of these. 42 00:04:03,320 --> 00:04:05,520 This wireframe intersection point. 43 00:04:05,690 --> 00:04:06,920 These will be your data points 44 00:04:10,000 --> 00:04:13,430 the third type is a surface top you 45 00:04:16,140 --> 00:04:22,320 this surface top dog also known as Condor chart is how you will see that surface when you're viewing 46 00:04:22,320 --> 00:04:23,910 it from the top. 47 00:04:23,910 --> 00:04:31,450 So that same three dimensional figure if you look at it from the top this is how it will appear to you. 48 00:04:31,580 --> 00:04:37,750 However it does not give you the idea of where the value is large and where it is small. 49 00:04:37,830 --> 00:04:46,370 It is telling you where the value is similar but not when it is large or small before tapers. 50 00:04:46,470 --> 00:04:50,470 This can do a lot but in a wide frame. 51 00:04:50,520 --> 00:04:59,580 So this is we draw surface chart so for a start sometimes look very appealing but they are very rarely 52 00:04:59,580 --> 00:05:08,910 used and you may not use them in your professional life mainly because it is very difficult to understand 53 00:05:09,090 --> 00:05:12,600 and predictive value at each point of this stuff.