1 00:00:00,150 --> 00:00:03,510 No, first we will draw a line chart. 2 00:00:04,800 --> 00:00:06,850 For overnight profit data. 3 00:00:07,470 --> 00:00:11,270 So this is the line that we want from this data. 4 00:00:13,010 --> 00:00:14,570 So to draw a line chart. 5 00:00:16,510 --> 00:00:17,500 Go to insert. 6 00:00:18,570 --> 00:00:23,520 Click on this insert line and reach out and select. 7 00:00:24,690 --> 00:00:26,800 This line with Marguerita. 8 00:00:30,050 --> 00:00:37,430 Here, the first step is to select data, so go to design tab and click on select data. 9 00:00:39,580 --> 00:00:49,960 Here on the legend entry, authorities say we have to select the data that we want on the Y-axis and 10 00:00:49,960 --> 00:00:51,460 on the horizontal axis. 11 00:00:52,740 --> 00:00:55,140 We have to give this year's column. 12 00:00:57,440 --> 00:00:58,700 So click on that. 13 00:00:59,610 --> 00:01:04,890 The city's name is this nonprofit, and the city's value is. 14 00:01:07,580 --> 00:01:08,060 This. 15 00:01:10,790 --> 00:01:16,760 So this is our first cities that is net profit now, the second cities we want is net profit margin. 16 00:01:17,150 --> 00:01:18,920 So again, click on ADD. 17 00:01:19,790 --> 00:01:22,910 The city's name is net profit margin and. 18 00:01:23,890 --> 00:01:27,220 The city's values are located or here. 19 00:01:29,790 --> 00:01:30,450 So click on the. 20 00:01:32,160 --> 00:01:39,210 Now for horizontal axis, currently we are getting one, two, three, four, five and six, but we 21 00:01:39,210 --> 00:01:40,310 don't want this value. 22 00:01:40,320 --> 00:01:46,320 We want the air values to click on edit and select the range. 23 00:01:50,330 --> 00:01:53,430 So now our chart is looking good. 24 00:01:53,550 --> 00:01:54,650 Means we have. 25 00:01:55,660 --> 00:02:02,710 I did all the data horizontal axis is looking good on the vertical axis, we have to see this net profit 26 00:02:02,710 --> 00:02:04,040 margin and net profit. 27 00:02:05,080 --> 00:02:13,660 So click on OK, now you can see that the net profit values are in hundreds of thousand, whereas the 28 00:02:13,660 --> 00:02:19,040 net profit values are in decimal point zero point zero eight or zero point zero nine. 29 00:02:19,690 --> 00:02:22,600 So that's way for this net profit margin. 30 00:02:23,080 --> 00:02:26,390 All our values are lying near to zero. 31 00:02:27,100 --> 00:02:31,090 We cannot analyze these values by looking at the graph. 32 00:02:32,460 --> 00:02:40,320 For such cases, when there is a huge difference between both of the cities numbers, we can use secondary 33 00:02:40,320 --> 00:02:40,910 access. 34 00:02:41,730 --> 00:02:43,560 So click on your cities. 35 00:02:43,860 --> 00:02:46,410 So, for example, this is our cities. 36 00:02:48,860 --> 00:02:52,880 Try to click on this now, our second series of selected. 37 00:02:55,580 --> 00:03:01,550 Now, go to this option, third option and click on secondary access. 38 00:03:03,080 --> 00:03:06,830 Now, just after plugging the secondary axis, you will find that. 39 00:03:07,610 --> 00:03:14,750 Secondary axis appears on the right hand side of your chart, and here you can see that the values are 40 00:03:14,750 --> 00:03:17,660 from zero to 14 percent. 41 00:03:19,740 --> 00:03:22,500 So that's so we add secondary access. 42 00:03:24,050 --> 00:03:32,450 Now, these two lines are coinciding and it may be confusing for other users to analyze this. 43 00:03:33,520 --> 00:03:41,520 So we will shift this axis a little bit down so that these two lanes are separated now. 44 00:03:41,560 --> 00:03:46,790 To do that, we can tweak the upper limit and lower limit of the secondary axis. 45 00:03:46,800 --> 00:03:48,580 So click on your secondary axis. 46 00:03:49,940 --> 00:03:57,860 Selected and go to this exercise option and in this exercise options. 47 00:03:58,840 --> 00:04:03,550 You can set bond for your secondary or primary access. 48 00:04:04,510 --> 00:04:07,930 So right now, the lowest or minimum bond is zero. 49 00:04:08,110 --> 00:04:15,940 That's why the axis is starting from zero and the maximum bond is one one four or 14 percent. 50 00:04:16,000 --> 00:04:19,470 That's where the X's values are going for 10 percent. 51 00:04:22,350 --> 00:04:28,560 Now we can change this minimum one two point zero five or five percent. 52 00:04:31,110 --> 00:04:36,030 And we can tweak this upper bound to guarantee. 53 00:04:37,140 --> 00:04:39,120 20 percent or 2.0. 54 00:04:41,720 --> 00:04:47,930 So you can see that now both of these two lines are separated and we can clearly identify the pattern 55 00:04:48,500 --> 00:04:51,680 for this orange lane, we can use the secondary access. 56 00:04:51,680 --> 00:04:57,140 And for this blue line, which is a nonprofit, we can use the primary access. 57 00:04:58,240 --> 00:05:06,570 Now, the job titles are missing and the agents are also missing, so to add to our title and digital 58 00:05:06,580 --> 00:05:11,140 agents, we can click on this plus icon, go to this legend. 59 00:05:12,400 --> 00:05:18,370 And using this drilldown menu, we can also select the location for legends. 60 00:05:19,360 --> 00:05:22,190 I want legends to be at the bottom of my chart. 61 00:05:22,780 --> 00:05:28,070 Now you can see that we have a and non profit and that profit margin to return. 62 00:05:29,480 --> 00:05:31,100 On their third title, Esben. 63 00:05:32,180 --> 00:05:33,770 So click on title. 64 00:05:34,700 --> 00:05:37,460 And the title is Profit and Profit Margin. 65 00:05:39,070 --> 00:05:43,790 Just copy and paste it in your chart data. 66 00:05:51,170 --> 00:05:58,060 And he says, now you can see that our chart is ready, we are able to identify patterns in our data. 67 00:05:58,110 --> 00:06:04,710 We have the title, we have our agents and we are ready to line cities in our line to.