1 00:00:01,450 --> 00:00:04,640 Now before we start to learn about different chart babes. 2 00:00:04,900 --> 00:00:09,900 Let us first look at different elements that got to do the chart. 3 00:00:09,910 --> 00:00:15,280 Here we have a chart displaying graph of profit margin and income. 4 00:00:15,280 --> 00:00:24,610 Income is plotted as vertical columns and the profit margin is plotted as line with squared markers. 5 00:00:24,670 --> 00:00:31,760 This income and profit margin data is called data series and the individual value of these data series 6 00:00:32,230 --> 00:00:38,860 such as this single bar or this particular marker are known as data points. 7 00:00:38,860 --> 00:00:45,270 So remember a data series is a combination of several data points. 8 00:00:45,340 --> 00:00:55,270 Now this horizontal axis is known as category axis or just horizontal axis and the label at the bottom. 9 00:00:55,390 --> 00:01:01,450 These months values written here are known as the horizontal axis labels. 10 00:01:01,600 --> 00:01:09,730 Now similar is denominated for the vertical axis but if you notice in this chart we have two words equal 11 00:01:09,730 --> 00:01:10,210 access 12 00:01:13,080 --> 00:01:20,760 the one on the left is called primary vertical axis and one on the right is called these secondary vertical 13 00:01:20,820 --> 00:01:22,340 axis. 14 00:01:22,440 --> 00:01:29,280 We have created these two axis because there is a huge difference in the values of income and profit 15 00:01:29,280 --> 00:01:34,560 margins while the values of income is in the thousand. 16 00:01:34,590 --> 00:01:43,380 The value of profit margin is in decimal points if the profit margin were plotted using the left axis 17 00:01:43,950 --> 00:01:48,720 the line for profit margin would not be even visible. 18 00:01:48,720 --> 00:01:54,020 It will be so close to the horizontal axis that we would not be able to even see it. 19 00:01:54,690 --> 00:02:00,780 Therefore adding a separate secondary vertical axis solve this problem. 20 00:02:00,780 --> 00:02:06,190 Now we are able to add two different scales on a single graph. 21 00:02:06,690 --> 00:02:15,240 Again the one on the left is known as primary vertical axis and its label is known as primary vertical 22 00:02:15,300 --> 00:02:17,010 axis labels. 23 00:02:17,310 --> 00:02:22,410 So these values are two hundred forty thousand dollars one hundred ninety thousand dollars. 24 00:02:22,410 --> 00:02:30,240 These are the primary vertical axis labels and this one on the right is known as secondary vertical 25 00:02:30,240 --> 00:02:35,130 axis and its label are known as secondary axis labels 26 00:02:38,220 --> 00:02:45,120 you can also notice that we have this informative box on the right hand side displaying what these bars 27 00:02:45,300 --> 00:02:53,160 and lines represent these two values are known as legions of the charts. 28 00:02:53,360 --> 00:03:00,790 So this blue box is representing the income and these orange line with orange markers is giving us the 29 00:03:00,790 --> 00:03:03,040 profit margin. 30 00:03:03,100 --> 00:03:09,730 You can also notice that we have these numerical values on the top of the profit margin. 31 00:03:09,820 --> 00:03:15,040 These values are known as data labels. 32 00:03:15,040 --> 00:03:23,960 We also have this chart title on the top containing the value income and profit this chart also contains 33 00:03:24,230 --> 00:03:32,900 horizontal grid lines good lines are basically the extension of the vertical axis scales which makes 34 00:03:32,900 --> 00:03:37,610 it easier for the viewer to determine the magnitude of these data points. 35 00:03:37,610 --> 00:03:47,420 So for example if I want to find out the value of income for the month of April I can see that it is 36 00:03:47,420 --> 00:03:55,100 lagging slightly above this one hundred forty thousand dollars grid landmark so I can approximate it 37 00:03:55,100 --> 00:03:59,060 to be around one hundred fifty thousand dollars. 38 00:03:59,060 --> 00:04:07,310 If you hover over the bar it is giving us the value of 152 Holden so it is a pretty good estimate for 39 00:04:07,310 --> 00:04:10,420 the value. 40 00:04:10,990 --> 00:04:17,160 In addition to this all charts have a chart area which is this entire background area of the chart. 41 00:04:17,230 --> 00:04:25,180 So this highlighted square this outer boundary is containing the chart area and then we have a plot 42 00:04:25,180 --> 00:04:27,170 area plot area. 43 00:04:27,280 --> 00:04:36,160 Shows the actual chart including deported data the Axis and the axis labeled to this small square inside 44 00:04:36,160 --> 00:04:37,860 the target area is the plot area 45 00:04:40,920 --> 00:04:44,590 so that's all for denominator of charts. 46 00:04:44,600 --> 00:04:47,470 But why did we learn all of this. 47 00:04:47,750 --> 00:04:57,050 We learned all of this because Excel has independent formatting options for all of these elements and 48 00:04:57,050 --> 00:05:06,410 it will be really helpful to divide any formatting task into manageable individual segments and then 49 00:05:06,740 --> 00:05:13,160 we can format each of these individual elements separately. 50 00:05:13,160 --> 00:05:21,110 I know remembering them must be a difficult task but everyone who is trying to master chart should know 51 00:05:21,260 --> 00:05:28,850 this nominee Ledger in the coming videos of this course you will be learning about how to format each 52 00:05:28,850 --> 00:05:31,400 and every individual element of the chart.