In this video, we will learn about Sparling's spy claims that minecart that resulted in a cell in exile,
as you can see here, I have fusebox lines drawn.
You can see in this single cell face, I have this small line chart which is representing the trend
of these values.
So spotlights are usually used to show the trend over time or the variation in the dataset.
However, since small claims are really tiny, they have limited functionality.
Despite that, small claims are great.
As you can create this easily to show train and make your reports and dashboards look more reader friendly.
There are three types of spotlight, I show you where to find these Parkland's go to insert.
And in this section, you can see there are three types of spotlights, line column and will loss to
line, will blood Alinejad and a Singleton column will be a column chart and the loss will be a plus
and minus type of chart.
So let's learn how to create a sparkling.
And delete this.
Go to insert line, so this will be a line type of smuggling, the data range is from see for yourself
to invite.
And the selling, which I want is all only if you want to change it.
You can change it here.
Click on OK, and here's a sparkling.
So as I told you, it's a small version of the line chart.
Let's draw a line chart.
Want to compare whether this sparklingly the same as the line chart.
So this is a line, Jack.
You can see that the trend that we will see in the line chart is also represented by the small sparkling.
So whenever you are sharing a large amount of data with some other people in your workplace and in your
worksheet, you cannot draw a big chart.
A small spotlight can serve the purpose of highlighting that there is something in the data that you
are offering them.
One thing you should note here is that sense of sparkling is residing within a cell.
So if you change the size of this, the size of Scotland will also change.
So if I increase the height and weight, the height and weight of Scotland will also change.
Also, if I merge the cells around it, this line will be drawn in all those moist cells.
So this was the line I was partly second one is the column type, it is similar to the line line.
So let us create a column by Ross partly.
I'll clear this to clear, as Portland, you have to go to design option, and within that there is
a clear return.
So clear all.
So right now, only one cell is selected 06.
And go to call them partly.
Collecting data location.
OK, so you can see here the column outline, the height of the bar is representing the value of each
data point.
If you want to expand it to multiple cells, you can master cells or you can decide the cell to have
a bigger spogli.
This last type of spotlight is a win loss or positive, negative type of sparkling.
So whenever devalues positive, it will be shown as a blue box above an imaginary axis and whenever
it is negative, it will be shown as a red box below that imaginary axis.
So to create this, let us glitter trust.
The Los.
OK, so you can see here that when large type of spotlight, the only difference between a column titled
Sparkling and Sparkling is the height of column in a column.
Spogli is giving us the relative value of that particular data point, whereas in this pin loss type
of spotlit, the height of column is irrelevant.
If it is above the axis, it is positive.
If it is below the axis, it is negative.
So it is plus or minus or below type of graph.
So this is how we create spotlights or minecart, you can also format these spotlights, you can change
its color, you can change its marker color.
So all those options are also available.
We are not going to discuss it in this lecture.