1
00:00:01,410 --> 00:00:07,890
Now, before we start to learn about the tapes, let us first look at different elements that constitute

2
00:00:07,890 --> 00:00:08,340
a chart.

3
00:00:09,840 --> 00:00:17,910
Here we have a chart displaying graph of profit margin and income income as bloated as vertical columns,

4
00:00:18,600 --> 00:00:23,410
and the profit margin is plotted as line with square markers.

5
00:00:24,630 --> 00:00:31,560
This income and profit margin data is called data series, and the individual value of this dataset

6
00:00:31,560 --> 00:00:37,810
is such as this single bar or this particular marker are known as data points.

7
00:00:38,790 --> 00:00:43,830
So remember, a dataset is a combination of several data points.

8
00:00:45,300 --> 00:00:54,650
Now this horizontal axis is known as category X's or just horizontal axis and the label at the bottom.

9
00:00:55,350 --> 00:01:00,320
This month's values written here are known as the horizontal axis labels.

10
00:01:01,530 --> 00:01:05,160
Now, similar is the nomenclature for the vertical axis.

11
00:01:05,910 --> 00:01:10,200
But if you notice in this chart, we have two vertical axis.

12
00:01:13,030 --> 00:01:20,770
The one on the left is called primary vertical axis and one on the right is called the secondary vertical

13
00:01:20,770 --> 00:01:21,310
axis.

14
00:01:22,390 --> 00:01:29,290
We have created these two axis because there is a huge difference in the values of income and profit

15
00:01:29,290 --> 00:01:33,940
margins while the values of income is in the thousands.

16
00:01:34,520 --> 00:01:38,110
The value of profit margin is in decimal points.

17
00:01:39,820 --> 00:01:47,440
If the profit margin were plotted using the left axis, the line for profit margin would not be even

18
00:01:47,440 --> 00:01:47,910
visible.

19
00:01:48,610 --> 00:01:55,600
It will be so close to the horizontal axis that we would not be able to even see it, therefore, adding

20
00:01:55,600 --> 00:01:59,500
a separate secondary vertical axis solve this problem.

21
00:02:00,730 --> 00:02:05,020
Now we are able to add two different scales on a single graph.

22
00:02:06,580 --> 00:02:15,250
Again, the one on the left is known as Primary Vertical Axis, and its label is known as primary vertical

23
00:02:15,250 --> 00:02:16,360
axis labels.

24
00:02:17,260 --> 00:02:22,040
So these values are two hundred forty thousand dollars, one hundred ninety thousand dollars.

25
00:02:22,360 --> 00:02:25,450
These are the primary vertical axis labels.

26
00:02:27,130 --> 00:02:34,570
And this one on the right is known as secondary vertical axis and its label are known as secondary axis

27
00:02:34,570 --> 00:02:35,110
labels.

28
00:02:38,160 --> 00:02:45,210
You can also notice that we have this informative box on the right hand side displaying what these bars

29
00:02:45,210 --> 00:02:46,680
and lines represent.

30
00:02:48,780 --> 00:02:57,680
These two values are known as Legends of the Arts to this blue bar is representing the income and these

31
00:02:57,690 --> 00:03:01,600
orange line with orange markers is giving us the profit margin.

32
00:03:03,030 --> 00:03:09,010
You can also notice that we have these numerical values on the top of the profit margin.

33
00:03:09,780 --> 00:03:12,670
These values are monice data labels.

34
00:03:15,000 --> 00:03:20,130
We also have this chart title on the top containing the value, income and profit.

35
00:03:22,440 --> 00:03:25,370
This chart also contains horizontal grid lines.

36
00:03:26,700 --> 00:03:34,290
Good lines are basically the extension of the vertical axis scales, which makes it easier for the viewer

37
00:03:34,440 --> 00:03:37,230
to determine the magnitude of the data points.

38
00:03:37,560 --> 00:03:46,470
So, for example, if I want to find out the value of income for the month of April, I can see that

39
00:03:47,100 --> 00:03:55,260
it is slightly above this one hundred forty thousand dollars gridline mark so I can approximate it to

40
00:03:55,260 --> 00:03:58,250
be around one hundred fifty thousand dollars.

41
00:03:58,950 --> 00:04:04,780
If you hover over the bar, it is giving us the value of one hundred fifty two thousand.

42
00:04:04,890 --> 00:04:07,800
So it is a pretty good estimate for the value.

43
00:04:10,850 --> 00:04:16,930
In addition to this, all charts have a chart area, which is this entire background area of the chart.

44
00:04:17,180 --> 00:04:22,330
So this highlighted square, this outer boundary is containing the chart area.

45
00:04:23,690 --> 00:04:25,550
And then we have a plot area.

46
00:04:26,300 --> 00:04:32,910
Plot area shows the actual chart, including the data, the axis and the axis labels.

47
00:04:34,070 --> 00:04:37,910
So this small square inside the target area is the plot area.

48
00:04:40,850 --> 00:04:46,360
So that's all for denominate later of charge, but why did we learn all of this?

49
00:04:47,690 --> 00:04:55,670
We learned all of this because Exel has independent formatting options for all of these elements.

50
00:04:56,810 --> 00:05:06,050
And it will be really helpful to divide any formatting task into manageable individual segments and

51
00:05:06,050 --> 00:05:10,950
then we can format each of these individual elements separately.

52
00:05:13,040 --> 00:05:21,190
I know remembering them must be a difficult task, but everyone was trying to MasterCharge should know

53
00:05:21,230 --> 00:05:28,850
this nomenclature in the coming radius of this course, you will be learning about how to format each

54
00:05:28,850 --> 00:05:31,430
and every individual element of Richard.