1 00:00:01,780 --> 00:00:04,930 And this we do, we learn about aleatoric. 2 00:00:07,270 --> 00:00:09,800 Area charts are very similar to line charts. 3 00:00:11,110 --> 00:00:15,290 The only thing is the area below the line has been cleared. 4 00:00:17,260 --> 00:00:19,360 You can look at this example that I've shown here. 5 00:00:22,320 --> 00:00:28,750 In this data, the first column is giving us the short sales in four quarters. 6 00:00:30,600 --> 00:00:34,740 This right graph is the line chart of this, these forward values. 7 00:00:36,400 --> 00:00:39,420 The left chart is the area graph. 8 00:00:40,010 --> 00:00:43,540 You can see that area chart is same as line chart. 9 00:00:43,590 --> 00:00:47,850 Only thing is that the area below this line is colored in this chart. 10 00:00:50,780 --> 00:01:00,260 Now, if I want to have multiple detectives in an area talked to, just like Landshark will have multiple 11 00:01:00,260 --> 00:01:06,260 lines and area blue, all those lines will be colored and it will be difficult to interpret. 12 00:01:07,010 --> 00:01:08,230 Let us see how to do that. 13 00:01:10,370 --> 00:01:11,450 I'll add a legend. 14 00:01:11,450 --> 00:01:13,820 Her name is Bantz. 15 00:01:17,560 --> 00:01:22,570 And the series is these four values, these values. 16 00:01:24,680 --> 00:01:27,940 Another one I thought was a name. 17 00:01:31,560 --> 00:01:35,030 And these four are the values. 18 00:01:38,430 --> 00:01:40,650 We can read the letters also. 19 00:01:42,290 --> 00:01:42,770 OK? 20 00:01:45,080 --> 00:01:45,520 OK. 21 00:01:47,760 --> 00:01:55,530 So you can see now we have three cities and this table is missing the box, so, um, first of all, 22 00:01:55,530 --> 00:02:01,650 not able to identify which color is representing which cities, letter box or the. 23 00:02:11,630 --> 00:02:12,050 So. 24 00:02:20,900 --> 00:02:30,110 So you can see we have three cities in this single chart and most of the blue cities which is representing 25 00:02:30,110 --> 00:02:38,210 the shirttails in the fourth quarter, we are not able to see it because it is hidden behind the other 26 00:02:38,210 --> 00:02:38,890 two cities. 27 00:02:39,920 --> 00:02:46,670 If you want to look at the values of cities, we need to increase the transparency of the bank city 28 00:02:46,670 --> 00:02:47,710 and the other cities. 29 00:02:48,560 --> 00:02:51,680 You know how to do it if you select any particular cities. 30 00:02:54,830 --> 00:03:01,640 And go to formatted as the cities in the solid file, you can add transparency by increasing it here 31 00:03:02,330 --> 00:03:07,790 you can see that now you can look at the shared dataset is. 32 00:03:12,610 --> 00:03:16,000 Now, let us increase the transparency of others to the series. 33 00:03:21,460 --> 00:03:25,300 And also change its color so that it does not match with paint. 34 00:03:28,230 --> 00:03:37,260 So so now you can see the three little cities and you can also understand why it is very difficult to 35 00:03:37,260 --> 00:03:39,000 use this ideograph. 36 00:03:40,360 --> 00:03:43,420 Since the datasets are overlapping with each of the. 37 00:03:45,450 --> 00:03:48,860 One solution to this is using the stacked area. 38 00:03:51,180 --> 00:03:54,180 So if you change the area to tape. 39 00:03:59,200 --> 00:04:05,080 The second option is the stack, the chart you can see in this example here. 40 00:04:06,950 --> 00:04:15,830 So this is basically putting the these values one way or another, so in cordovan, the short sales 41 00:04:15,830 --> 00:04:18,070 was really around 470. 42 00:04:19,490 --> 00:04:27,260 The next 100 is pulled from this 470 value and it reaches up to nearly 6500. 43 00:04:29,880 --> 00:04:35,840 The third value, which is for others, which is 564, is stacked on top of it. 44 00:04:36,840 --> 00:04:44,130 So now you can easily see all the three values and you can also see the contribution of each of these 45 00:04:44,130 --> 00:04:45,760 cities to the total. 46 00:04:47,910 --> 00:04:54,300 And just like Bordetella in charge, the third option in this graph also is 100 percent stacked in. 47 00:04:58,300 --> 00:05:05,240 In which the total will be said 200 percent and the contribution of each individual product will be 48 00:05:05,240 --> 00:05:07,720 shown as a percentage of total. 49 00:05:10,440 --> 00:05:18,900 The other options and area is a 3-D area, 3-D, Tigrinya and 300 percent area there to select 3-D art. 50 00:05:19,800 --> 00:05:25,350 You can see that each of these datasets is now 3-D. 51 00:05:25,350 --> 00:05:33,480 One altitude of this fall is in line with the value at each data point. 52 00:05:34,880 --> 00:05:45,230 You can see again, this third dataset is more or less so, although this chart may look visually appealing 53 00:05:45,230 --> 00:05:51,980 to a lot of people, census data is often obscured behind the other datasets. 54 00:05:52,550 --> 00:05:57,100 This chart type is not recommended for business use most of the names.