1 00:00:02,200 --> 00:00:11,470 In this video, we will learn about lifeguards Lichaj are often used to block continuous data and are 2 00:00:11,470 --> 00:00:13,420 useful for identifying trends. 3 00:00:14,770 --> 00:00:22,300 For example, flooding daily sales as a lifeguard may enable you to identify sales fluctuations over 4 00:00:22,300 --> 00:00:22,610 time. 5 00:00:24,910 --> 00:00:32,510 Normally, the category axis or the or the horizontal axis or a line chart displays equal intervals. 6 00:00:35,380 --> 00:00:42,220 In this example here, for each year, I have the contribution to sales of different products. 7 00:00:43,150 --> 00:00:51,100 So this in this first line in the year 1953, the short sales were contributing to forty three point 8 00:00:51,100 --> 00:00:53,620 forty three point five percent of the total sales. 9 00:00:54,760 --> 00:00:56,920 And I have this data for next. 10 00:00:56,920 --> 00:00:59,320 Forty eight years, 2000. 11 00:01:01,910 --> 00:01:09,520 So when I plot a line chart of these three products, these three datasets come as three different lines, 12 00:01:10,820 --> 00:01:15,680 you can identify each dataset with different color and color. 13 00:01:16,010 --> 00:01:20,570 It is representing which product is given in this little box on the right. 14 00:01:23,410 --> 00:01:30,610 On the x axis, which is the horizontal axis, you can see that I have equally spaced interval of time, 15 00:01:30,610 --> 00:01:32,090 which is two years. 16 00:01:33,040 --> 00:01:35,160 Now, let us learn how to plot this line chart. 17 00:01:35,740 --> 00:01:36,940 I did this chart. 18 00:01:38,730 --> 00:01:43,350 We will select the whole table and we'll go to insert menu. 19 00:01:44,470 --> 00:01:46,990 And this is the icon for line chart. 20 00:01:49,420 --> 00:01:51,310 You can see there are a number of options here. 21 00:01:53,770 --> 00:01:59,980 Since Excel can automatically identify X and Y values, we can use the recommended chart option, which 22 00:01:59,980 --> 00:02:02,950 I told you is the one click method you can see. 23 00:02:03,850 --> 00:02:05,920 Here's the line for this table. 24 00:02:06,610 --> 00:02:06,970 Click on. 25 00:02:06,970 --> 00:02:07,320 Okay. 26 00:02:08,680 --> 00:02:10,390 And this line is created. 27 00:02:12,070 --> 00:02:13,510 What we need to do a lot of things. 28 00:02:13,510 --> 00:02:14,920 We need to do the job title. 29 00:02:14,920 --> 00:02:22,870 We need to give the Y axis title and we can change the positioning of this login box below. 30 00:02:25,960 --> 00:02:32,380 If you are not sure that Xolo selected the right, you can confirm by again going to the selected option. 31 00:02:33,700 --> 00:02:41,500 You can click on this and you can see that in the legend you have showed you can click on this edit 32 00:02:41,500 --> 00:02:41,860 button. 33 00:02:42,550 --> 00:02:50,650 The city's name is Schertz, which is great, and the city's values are from C six to C 53, which is 34 00:02:50,650 --> 00:02:51,400 also correct. 35 00:02:52,810 --> 00:02:56,320 So you can check for all other series also. 36 00:02:56,740 --> 00:03:01,450 And if it is okay, then you can use it on the horizontal axis. 37 00:03:01,570 --> 00:03:04,720 We should have years from 1953 to 2000. 38 00:03:05,620 --> 00:03:10,060 Excel automatically picked them correctly in case it was not built correctly. 39 00:03:10,060 --> 00:03:17,200 You can click on the edit button and then select the year range and let us click on OK. 40 00:03:19,660 --> 00:03:24,160 Now, as told earlier, you can change the title title, horizontal axis title. 41 00:03:24,160 --> 00:03:28,000 You can format all these just in the same way we did for budget. 42 00:03:29,290 --> 00:03:32,710 Now let us look at the different types of line chart available. 43 00:03:33,760 --> 00:03:35,950 Let's click on this change time button. 44 00:03:37,960 --> 00:03:40,000 You can see we have all these options. 45 00:03:40,000 --> 00:03:44,650 Alinejad the first one is selected, which is a simple line chart. 46 00:03:45,580 --> 00:03:48,340 If you go to the next one, it does that line chart. 47 00:03:49,390 --> 00:03:53,350 So its tag line chart is similar to this tag budget. 48 00:03:53,710 --> 00:03:58,480 The different datasets will be tied one on top of the other. 49 00:03:59,230 --> 00:04:03,550 So you can see first we have this short chart. 50 00:04:04,240 --> 00:04:09,780 On top of it, we will have the banked values and on top of that we will have the others values. 51 00:04:10,330 --> 00:04:17,410 So this band sales value is giving us these some of times, plus shared contribution. 52 00:04:18,760 --> 00:04:26,830 So for the year 1953, the band contribution point will be at ninety seven point four percent. 53 00:04:28,770 --> 00:04:34,950 Which is some of forty three point five percent plus fifty three point nine percent, and the third 54 00:04:34,950 --> 00:04:38,070 line, which is the others lane, will be the sum of all the three. 55 00:04:38,310 --> 00:04:42,150 So it will be a 100 percent contribution to those 200 percent. 56 00:04:44,880 --> 00:04:53,100 So this is tagline next, one hundred percent tagline since are totally 100 percent in this case, these 57 00:04:53,100 --> 00:04:58,870 two will be exactly the same in case you have the total to be not 100 percent. 58 00:04:59,850 --> 00:05:07,620 This represents that line will convert only totals to one hundred percent and the contribution of each 59 00:05:07,620 --> 00:05:10,540 product as a percentage of total. 60 00:05:12,150 --> 00:05:18,570 So as told earlier in budget also, it used to compare the contribution of different products to the 61 00:05:18,570 --> 00:05:18,890 total. 62 00:05:21,240 --> 00:05:23,720 Next comes line with Marko's. 63 00:05:24,240 --> 00:05:25,560 Let us select this and click on. 64 00:05:25,560 --> 00:05:32,620 OK, so you can see that for each data point there's a circle mark on the glove. 65 00:05:33,540 --> 00:05:35,400 This is highlighting that data point. 66 00:05:37,020 --> 00:05:43,740 If you have fewer number of points, you can use this to highlight the data point, which is constituting 67 00:05:43,740 --> 00:05:44,670 this line chart. 68 00:05:46,620 --> 00:05:49,080 Apart from that, it is exactly the same to this. 69 00:05:49,080 --> 00:05:50,850 And Plainchant does that. 70 00:05:50,850 --> 00:05:58,230 It has the markers which are identifying the individual data point, the other types of chart types 71 00:05:58,230 --> 00:05:58,700 available. 72 00:06:00,690 --> 00:06:06,870 These other two times are the same things that we discussed earlier, just that it will have markers 73 00:06:06,870 --> 00:06:07,290 with them. 74 00:06:08,910 --> 00:06:13,870 This last one is there is a 3D option of line, which doesn't really make sense. 75 00:06:13,890 --> 00:06:16,190 You can click on it to see what it creates. 76 00:06:18,150 --> 00:06:19,760 It doesn't really make any sense. 77 00:06:20,820 --> 00:06:27,030 I use a different dataset to show the change that that red line chart create. 78 00:06:27,390 --> 00:06:33,750 But even in that example, you will see that a 3D printer does not really make any sense when you're 79 00:06:33,750 --> 00:06:35,490 trying to convey a message using a chart. 80 00:06:38,640 --> 00:06:47,130 Now, let us create that simple one only I want to tell you one other point, which is you can add, 81 00:06:47,250 --> 00:06:54,120 since this one has no markers on it, you can, first of all, add to it to highlight the data point. 82 00:06:54,660 --> 00:06:59,470 And the second thing you can add is the data levels. 83 00:06:59,580 --> 00:07:05,460 If you want to highlight the value at each data point, you can have data labeled. 84 00:07:09,950 --> 00:07:18,740 So if I go to the labels and hover over the above option, you can see for each data point the value 85 00:07:18,740 --> 00:07:19,270 is order. 86 00:07:19,640 --> 00:07:26,320 Since it has a lot of data point, the chart is getting cluttered and it is not looking good at all. 87 00:07:28,340 --> 00:07:35,390 But if you have your data point and you want to highlight the exact value at each individual point, 88 00:07:36,020 --> 00:07:43,750 it is recommended that you use a data label so that at each point you can actually view the value there. 89 00:07:45,890 --> 00:07:50,690 Now let us discuss the treaty line chart I'm showing you. 90 00:07:50,690 --> 00:07:55,100 This does to make a point that it does not make any sense to draw the line. 91 00:07:56,330 --> 00:08:05,900 So here's a sample data of population in each of the three cities in different years if I make a line 92 00:08:05,900 --> 00:08:06,680 chart of this. 93 00:08:13,530 --> 00:08:22,410 If I may, because in Blanchard, you can easily see that this is the trend of population, mostly it 94 00:08:22,410 --> 00:08:30,540 is increasing for the certainty and identity and for delay in 2005 that a sudden increase in population. 95 00:08:31,230 --> 00:08:33,570 But if I create a three day chart for this. 96 00:08:36,490 --> 00:08:42,730 You can see that even with the grid lines, we are not really sure what are the values of London and 97 00:08:42,730 --> 00:08:45,180 certainly in terms of population. 98 00:08:46,510 --> 00:08:50,930 So instead of a graph, it is looking more like an optical illusion. 99 00:08:52,270 --> 00:08:56,870 That's why I never recommend to draw a 3-D line chart in any scenario. 100 00:08:58,930 --> 00:09:02,320 It is always preferable to draw a sample to the line chart.