1
00:00:01,330 --> 00:00:09,040
In this video, we will learn about Sparling's spy claims that minecart that resulted in a cell in exile,

2
00:00:09,850 --> 00:00:13,440
as you can see here, I have fusebox lines drawn.

3
00:00:14,110 --> 00:00:21,580
You can see in this single cell face, I have this small line chart which is representing the trend

4
00:00:22,420 --> 00:00:23,440
of these values.

5
00:00:25,330 --> 00:00:31,170
So spotlights are usually used to show the trend over time or the variation in the dataset.

6
00:00:31,900 --> 00:00:36,310
However, since small claims are really tiny, they have limited functionality.

7
00:00:38,560 --> 00:00:40,850
Despite that, small claims are great.

8
00:00:41,020 --> 00:00:48,400
As you can create this easily to show train and make your reports and dashboards look more reader friendly.

9
00:00:50,420 --> 00:00:56,810
There are three types of spotlight, I show you where to find these Parkland's go to insert.

10
00:00:59,060 --> 00:01:06,740
And in this section, you can see there are three types of spotlights, line column and will loss to

11
00:01:06,740 --> 00:01:16,010
line, will blood Alinejad and a Singleton column will be a column chart and the loss will be a plus

12
00:01:16,010 --> 00:01:17,450
and minus type of chart.

13
00:01:19,840 --> 00:01:22,120
So let's learn how to create a sparkling.

14
00:01:24,430 --> 00:01:25,300
And delete this.

15
00:01:29,630 --> 00:01:40,580
Go to insert line, so this will be a line type of smuggling, the data range is from see for yourself

16
00:01:42,290 --> 00:01:43,100
to invite.

17
00:01:44,980 --> 00:01:49,370
And the selling, which I want is all only if you want to change it.

18
00:01:49,390 --> 00:01:50,280
You can change it here.

19
00:01:50,740 --> 00:01:52,870
Click on OK, and here's a sparkling.

20
00:01:54,250 --> 00:01:57,540
So as I told you, it's a small version of the line chart.

21
00:01:57,910 --> 00:01:59,050
Let's draw a line chart.

22
00:01:59,050 --> 00:02:03,850
Want to compare whether this sparklingly the same as the line chart.

23
00:02:08,140 --> 00:02:09,280
So this is a line, Jack.

24
00:02:12,290 --> 00:02:19,490
You can see that the trend that we will see in the line chart is also represented by the small sparkling.

25
00:02:21,160 --> 00:02:28,000
So whenever you are sharing a large amount of data with some other people in your workplace and in your

26
00:02:28,000 --> 00:02:30,510
worksheet, you cannot draw a big chart.

27
00:02:30,720 --> 00:02:36,550
A small spotlight can serve the purpose of highlighting that there is something in the data that you

28
00:02:36,550 --> 00:02:37,330
are offering them.

29
00:02:38,850 --> 00:02:43,660
One thing you should note here is that sense of sparkling is residing within a cell.

30
00:02:44,520 --> 00:02:49,740
So if you change the size of this, the size of Scotland will also change.

31
00:02:50,010 --> 00:02:54,770
So if I increase the height and weight, the height and weight of Scotland will also change.

32
00:02:55,950 --> 00:03:03,990
Also, if I merge the cells around it, this line will be drawn in all those moist cells.

33
00:03:06,600 --> 00:03:14,030
So this was the line I was partly second one is the column type, it is similar to the line line.

34
00:03:15,180 --> 00:03:18,060
So let us create a column by Ross partly.

35
00:03:19,180 --> 00:03:25,570
I'll clear this to clear, as Portland, you have to go to design option, and within that there is

36
00:03:25,570 --> 00:03:26,560
a clear return.

37
00:03:26,980 --> 00:03:27,700
So clear all.

38
00:03:30,450 --> 00:03:33,930
So right now, only one cell is selected 06.

39
00:03:36,450 --> 00:03:38,700
And go to call them partly.

40
00:03:42,630 --> 00:03:45,540
Collecting data location.

41
00:03:45,570 --> 00:03:54,000
OK, so you can see here the column outline, the height of the bar is representing the value of each

42
00:03:54,000 --> 00:03:54,560
data point.

43
00:03:56,650 --> 00:04:05,890
If you want to expand it to multiple cells, you can master cells or you can decide the cell to have

44
00:04:05,890 --> 00:04:06,790
a bigger spogli.

45
00:04:09,600 --> 00:04:15,420
This last type of spotlight is a win loss or positive, negative type of sparkling.

46
00:04:17,370 --> 00:04:25,740
So whenever devalues positive, it will be shown as a blue box above an imaginary axis and whenever

47
00:04:25,740 --> 00:04:30,120
it is negative, it will be shown as a red box below that imaginary axis.

48
00:04:31,260 --> 00:04:34,080
So to create this, let us glitter trust.

49
00:04:40,790 --> 00:04:42,330
The Los.

50
00:04:47,470 --> 00:04:58,340
OK, so you can see here that when large type of spotlight, the only difference between a column titled

51
00:04:58,380 --> 00:05:03,280
Sparkling and Sparkling is the height of column in a column.

52
00:05:03,280 --> 00:05:11,740
Spogli is giving us the relative value of that particular data point, whereas in this pin loss type

53
00:05:11,740 --> 00:05:16,030
of spotlit, the height of column is irrelevant.

54
00:05:17,290 --> 00:05:19,860
If it is above the axis, it is positive.

55
00:05:19,960 --> 00:05:22,110
If it is below the axis, it is negative.

56
00:05:22,480 --> 00:05:26,260
So it is plus or minus or below type of graph.

57
00:05:27,570 --> 00:05:36,080
So this is how we create spotlights or minecart, you can also format these spotlights, you can change

58
00:05:36,080 --> 00:05:38,780
its color, you can change its marker color.

59
00:05:39,030 --> 00:05:40,690
So all those options are also available.

60
00:05:40,890 --> 00:05:43,310
We are not going to discuss it in this lecture.