1 00:00:01,870 --> 00:00:11,090 In this we do we learn about idiot art idea charts are very similar to line charts. 2 00:00:11,170 --> 00:00:17,320 The only thing is the idea below the line has been colored. 3 00:00:17,320 --> 00:00:19,330 You can look at this example that I've shown. 4 00:00:22,570 --> 00:00:23,950 This data. 5 00:00:23,950 --> 00:00:30,640 The first column is giving us t shirt sealed in four quarters. 6 00:00:30,640 --> 00:00:33,650 This right graph is the line chart of this. 7 00:00:33,850 --> 00:00:43,650 These four values the left chart is the area graph you can see that area chart is same as line chart. 8 00:00:43,660 --> 00:00:47,830 Only thing is that the area below this line is colored in this chart. 9 00:00:50,860 --> 00:00:59,020 Now if I want to have multiple data cities in an eight year chart so just like line chart will have 10 00:00:59,800 --> 00:01:06,990 multiple lines an area blue all those lines will be colored and it will be difficult to interpret it. 11 00:01:07,060 --> 00:01:10,200 Let us see how to do that. 12 00:01:10,480 --> 00:01:13,840 I'll add a legend Her name is band 13 00:01:17,660 --> 00:01:19,390 and this series is. 14 00:01:20,020 --> 00:01:24,220 These were values as it is values. 15 00:01:24,790 --> 00:01:27,930 Another one of those is a name 16 00:01:31,750 --> 00:01:38,050 and these for arty value. 17 00:01:38,500 --> 00:01:40,690 We're gonna dig deeper learn to let us hold her. 18 00:01:42,330 --> 00:01:42,750 Okay. 19 00:01:45,160 --> 00:01:45,530 Okay. 20 00:01:47,820 --> 00:01:54,350 So you can see now we have three cities and this table is missing the legend Boxall. 21 00:01:54,390 --> 00:02:01,360 Um first of all not able to identify which color is representing which cities later the login box or 22 00:02:01,360 --> 00:02:01,600 the 23 00:02:11,580 --> 00:02:11,920 So 24 00:02:20,840 --> 00:02:30,090 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,090 --> 00:02:33,240 these short sales in the fourth quarters. 26 00:02:33,420 --> 00:02:39,810 We are not able to see it because it is hidden behind the other two cities. 27 00:02:39,990 --> 00:02:46,260 If you want to look at the values of shared cities we need to increase the transparency of the parent 28 00:02:46,260 --> 00:02:48,630 city and the other cities. 29 00:02:48,630 --> 00:02:49,590 You know how to do it. 30 00:02:49,800 --> 00:02:51,660 If you select any particular date as it is 31 00:02:54,950 --> 00:03:02,070 and go to format data cities and the Solid V you can add transparency by increasing your debt. 32 00:03:02,450 --> 00:03:12,170 You can see that now you can look at the showed greater cities. 33 00:03:12,680 --> 00:03:15,970 Now let us increase the transparency of those two cities 34 00:03:21,590 --> 00:03:25,280 and also to engage scholars so that it does not match would find 35 00:03:28,170 --> 00:03:29,120 so. 36 00:03:29,260 --> 00:03:37,240 So now you can see the three leaders cities and you can also understand why it is very difficult to 37 00:03:37,240 --> 00:03:45,370 use this area graph since these data cities are overlapping with each other. 38 00:03:45,510 --> 00:03:50,270 One solution to this is using the staggered idea chart. 39 00:03:51,210 --> 00:03:54,180 So if you change the area chart type 40 00:03:59,280 --> 00:04:05,070 the second option is the stack data chart you can see in this example here. 41 00:04:07,020 --> 00:04:11,600 So this is basically putting the data series values one way or another. 42 00:04:12,630 --> 00:04:20,440 So in quarter 1 these short sales was merely add on 470 meet next. 43 00:04:20,460 --> 00:04:27,210 Twelve hundred is pulled from this 470 value and it reaches up to nearly sixteen hundred 44 00:04:29,910 --> 00:04:36,050 deterred value which is for others with just 564 is stacked on top of it. 45 00:04:36,880 --> 00:04:44,070 So now you can easily see all the three values and you can also see the contribution of each of these 46 00:04:44,070 --> 00:04:45,780 cities to the total. 47 00:04:48,030 --> 00:04:54,720 And just like bar Dart a line chart B third option in this graph also is a 100 percent stack area chart 48 00:04:58,540 --> 00:05:05,570 in which the total will be set 200 percent and the contribution of each individual product will be shown 49 00:05:06,530 --> 00:05:10,080 as a percentage of total. 50 00:05:10,490 --> 00:05:18,890 The other options and ADR chart is a 3D area 3D tag media and 3D and represent area to select 3D a chart 51 00:05:19,880 --> 00:05:30,930 you can see that each of these data series is now 3D one altitude of this fall is a line which is you 52 00:05:30,930 --> 00:05:39,520 presenting the value at each data point you can see again this term data series is more or less dead. 53 00:05:41,330 --> 00:05:49,910 So although this chart may look visually appealing to a lot of people since the day is often obscured 54 00:05:49,940 --> 00:05:57,110 behind the other data series this chart type is not recommended for business use most of the names.