1 00:00:02,310 --> 00:00:11,330 In this video we will learn about line charts line charts are often used to block continuous data and 2 00:00:11,330 --> 00:00:14,420 are useful for identifying trends. 3 00:00:14,820 --> 00:00:22,290 For example plodding daily sales as a line chart may enable you to identify sales fluctuations over 4 00:00:22,290 --> 00:00:24,960 time. 5 00:00:24,960 --> 00:00:35,140 Normally the category axis or the or b horizontal axis bottom line chart displays equal intervals. 6 00:00:35,490 --> 00:00:42,980 In this example here for each year I have the contribution to sales of different product. 7 00:00:43,200 --> 00:00:47,620 So this in this first line in the year 1953. 8 00:00:47,670 --> 00:00:53,250 This shirt sales were contributing to forty three point forty three point five percent of the total 9 00:00:53,270 --> 00:00:58,530 it and I have this data for next forty eight years. 10 00:00:58,660 --> 00:01:09,100 Take 2000 so when I plot a line chart of these three products these three data these come as three different 11 00:01:09,100 --> 00:01:17,500 lengths you can identify each data as it is with different color and the color is true is representing 12 00:01:17,500 --> 00:01:20,530 which product is given in this Legion box on the light 13 00:01:23,500 --> 00:01:26,920 on the x axis which is the horizontal axis. 14 00:01:26,920 --> 00:01:33,050 You can see that I have equally spaced interval of time which is two years. 15 00:01:33,100 --> 00:01:35,680 Now let us learn how to plot this line chart. 16 00:01:35,860 --> 00:01:38,800 I need this chart. 17 00:01:38,800 --> 00:01:43,410 We will select the water table and will go to Insert menu. 18 00:01:44,590 --> 00:01:48,740 And this is the icon for line chart. 19 00:01:49,450 --> 00:01:53,030 You can see there are a number of options here. 20 00:01:53,830 --> 00:01:59,980 Since Excel can automatically identify x and y values we can use the recommended chart option which 21 00:01:59,980 --> 00:02:03,950 I told you is the one click method you can see. 22 00:02:03,950 --> 00:02:08,490 There is a line just for this table to click on okay. 23 00:02:08,800 --> 00:02:14,920 And this line that is creating what we need to do a lot of things we need to do the job title. 24 00:02:14,920 --> 00:02:24,660 We need to give the y axis title and we can change the positioning of this religion box below. 25 00:02:26,080 --> 00:02:31,990 If you are not sure that Excel has selected the flight data you can confirm by again going to the selected 26 00:02:31,990 --> 00:02:33,400 option. 27 00:02:33,790 --> 00:02:39,940 You can click on this and you can see that in the legend you have showed. 28 00:02:40,480 --> 00:02:42,450 You can click on the edit button. 29 00:02:42,640 --> 00:02:51,630 The city's name is shows which is great and the city's values are from C six to C 53 which is also correct. 30 00:02:52,870 --> 00:02:56,610 So you can check for all other cities also. 31 00:02:56,830 --> 00:03:01,610 And if it is okay then you can use it on the horizontal axis. 32 00:03:01,630 --> 00:03:05,370 We should have years from 1953 to 2000. 33 00:03:05,800 --> 00:03:10,060 Excel automatically picked them correctly in case it was not being correctly. 34 00:03:10,060 --> 00:03:18,570 You can click on this edit button and then selected years range let us click on okay. 35 00:03:19,640 --> 00:03:24,220 Now as told earlier you can change the di da title horizontal axis title. 36 00:03:24,250 --> 00:03:29,310 You can format all these just in the same way we did for by chart. 37 00:03:29,350 --> 00:03:33,010 Now let us look at different types of line charts available. 38 00:03:33,850 --> 00:03:34,660 Let's click on this. 39 00:03:34,660 --> 00:03:43,210 Change our type button you can see we have all these options of line judge the this first one is selected 40 00:03:43,420 --> 00:03:44,610 which is a simple line Jack. 41 00:03:45,670 --> 00:03:53,280 If you go to the next one it just tag line chart so tag line chart is similar to this tag bar chart 42 00:03:53,740 --> 00:04:01,920 the different data series will be stacked one on top of the other so you can see first. 43 00:04:01,990 --> 00:04:05,360 We have this short chart on top of it. 44 00:04:05,370 --> 00:04:10,310 We will have the banks values and on top of that we'll have the others valued. 45 00:04:10,390 --> 00:04:17,410 So this band sees value is giving us these sum of banked plus shared contribution. 46 00:04:18,790 --> 00:04:29,020 So for the year 1953 the band contribution point will be at ninety seven point four percent with the 47 00:04:29,020 --> 00:04:35,470 sum of forty three point five percent plus fifty three point nine percent and the third line which is 48 00:04:35,470 --> 00:04:40,990 the others line will be the sum of all the three so it will be at 200 percent and its contribution to 49 00:04:40,990 --> 00:04:42,480 those two hundred percent. 50 00:04:44,930 --> 00:04:49,290 So the city's tagline next one is hundred percent tagline. 51 00:04:49,490 --> 00:04:54,900 Since our total is hundred percent in this case these two will be exactly same. 52 00:04:55,250 --> 00:04:57,980 In case you have these totals do we not. 53 00:04:57,980 --> 00:04:58,920 Hundred percent. 54 00:04:59,900 --> 00:05:07,610 This represents that Lane will convert only to adults to 100 percent and truly contribution of each 55 00:05:07,610 --> 00:05:10,540 product as a percentage of total. 56 00:05:12,170 --> 00:05:18,560 So as told earlier in budget also it is used to compare the contribution of different product to the 57 00:05:18,560 --> 00:05:21,290 total. 58 00:05:21,290 --> 00:05:24,000 Next comes line with markers. 59 00:05:24,320 --> 00:05:31,760 Let us select this and click on Okay so you can see that for each data point there is a circle mark 60 00:05:32,000 --> 00:05:33,620 on the glove. 61 00:05:33,620 --> 00:05:37,100 This is highlighting that data point. 62 00:05:37,100 --> 00:05:42,700 If you have fewer number of points you can use this to highlight the data point. 63 00:05:42,710 --> 00:05:46,610 We just constituting this line chart. 64 00:05:46,760 --> 00:05:49,690 Apart from that it is exactly same to the same building. 65 00:05:49,700 --> 00:05:50,850 Jack does that. 66 00:05:50,860 --> 00:06:00,470 It has the markers without identifying the individual reader point the other types of chart types available. 67 00:06:00,740 --> 00:06:05,200 These other two types are the same things that we discussed earlier. 68 00:06:05,210 --> 00:06:08,840 Just that it will have markers with them. 69 00:06:08,960 --> 00:06:13,900 This last one is and is a 3D option of lane which doesn't really make sense. 70 00:06:13,910 --> 00:06:18,290 You can click on it to see what it creates. 71 00:06:18,290 --> 00:06:20,960 It doesn't really make any sense. 72 00:06:20,960 --> 00:06:27,260 I use a different dataset to show the change that that 3D line judge create. 73 00:06:27,440 --> 00:06:33,740 But even in that example you will see that a 3D line chart doesn't really make any sense when you're 74 00:06:33,740 --> 00:06:34,750 trying to convey a message. 75 00:06:34,760 --> 00:06:38,070 Using a chart. 76 00:06:38,650 --> 00:06:41,500 Now let us create that simple one only. 77 00:06:41,870 --> 00:06:50,320 I want to tell you on that point which is you can add since this one has no markers on it. 78 00:06:50,450 --> 00:06:56,360 You can first of all add markers to it to highlight the data point and the second thing you can add 79 00:06:56,360 --> 00:06:59,650 is the data labels. 80 00:06:59,660 --> 00:07:05,480 If you want to highlight the value add each data point you can have data labeled 81 00:07:10,020 --> 00:07:17,960 so if I go to Data labels and hover over the above option you can see for each data point. 82 00:07:18,150 --> 00:07:19,300 The value is noted. 83 00:07:19,710 --> 00:07:26,280 Since it has a lot of data point the chart is getting cluttered and it is not looking good at all. 84 00:07:28,410 --> 00:07:35,340 But if you have fewer data points and you want to highlight the exact value at each individual point 85 00:07:36,120 --> 00:07:43,530 it is recommended that you use a data label so that at each data point you can actually view the value 86 00:07:43,530 --> 00:07:45,900 there. 87 00:07:45,960 --> 00:07:53,700 Now let us discuss the 3D line chart I'm showing you this does to make a point that it does not make 88 00:07:53,700 --> 00:07:55,380 any sense to draw through the line chart. 89 00:07:56,370 --> 00:08:04,650 So here's a sample data of population in each of the three cities in different years. 90 00:08:04,710 --> 00:08:06,690 If I make a line chart of this 91 00:08:13,160 --> 00:08:23,020 if I make us and blame chart you can easily see that this is the trend of population mostly it is increasing 92 00:08:23,020 --> 00:08:30,740 for the certainty and identity and for Delhi in 2005 that a sudden increase in population. 93 00:08:31,300 --> 00:08:33,580 But if I create a 3D chart for this 94 00:08:36,540 --> 00:08:42,960 you can see that even with the grid lanes we are not really sure what are the values of London answered 95 00:08:42,960 --> 00:08:46,570 me in terms of population. 96 00:08:46,560 --> 00:08:52,180 So instead of a graph it is looking more like an optical illusion. 97 00:08:52,260 --> 00:08:58,630 That's why I never recommend to draw a 3D line chart in any scenario. 98 00:08:59,040 --> 00:09:02,280 It is always preferable to draw a simple 2D line chart.