In this video we will learn about Spotlight spotlight and the many charge that reside in a cell in exile.
As you can see here I have used battlelines drawn.
You can see in this single cell all five.
I have this small line chart which is representing the trend of these values so spotlights are usually
used to show a trend over time or the variation in the dataset.
However since spot lines are really tiny they have limited functionality despite that smart lines are
great.
As you can create this easily to show a trend and make your reports and dashboard look more reader friendly.
There are three types of spotlight.
I tell you where to find this Portland go to insert and in this section you can see there are three
types of Spotlight line column and willows to line will plot a line Jack and a singleton column will
be a column chart and the loss will be a plus and minus table chart so let's learn how to create a sparkling
and delete this
go to insert line.
So this will be a line type post modeling their data range is from C5 for to inflate and the selling
which I wanted is Or finally if you want to change it you can change it here click on okay And here's
a sparkling.
So as I told you it's a small version of the line Jack let's draw a line chart want to compare whether
this spot line the same as the line Jack
so this is a line Jack.
You can see that that trend that we will see in the line chart is also represented by this small sparkling.
So whenever you are sharing a large amount of data with some other people in your workplace and in your
worksheet you can not draw big chart small sparkling can only the purpose of highlighting that there
is some trend in the data that you are offering them.
One thing you should know there is that sense of sparkling is residing within a cell.
So if you change the size of DC the size of sparkling will also change.
So if I increase the height and weight the height and weight of sparkling will also change that.
Also if I merge the cells around it this party line will be drawn in all those most fields
so this will the line of spotlight.
Second one is the column type.
It is similar to the line partly.
So let us create a column type sparkling I'll clear this to clear sparkling.
You have to go to design option and within that there is a clear pattern so clear all
so right now only one cell is elected or six and go to call them typos partly
collecting data live location.
Okay so you can see here's the column by sparkling.
The height of the bar is representing the value of each data point.
If you want the store expanded to multiple sales you then my store said all you can do is say is the
sale to have a bigger sparkling
this last type of spotlight is a win loss or positive negative people sparkling so whenever it devalues
positive it will be shown as a blue box above an imaginary axis.
Whenever it is negative it be shown as a red box below that imaginary axis.
So to create this let us glitter closed
the loss w orange Okay so you can see here's a very large type of sparkling.
The only difference between column type of sparkling and a Windows type of sparkling is the height of
column in a column sparkling is giving us the relative value of that particular data point.
Whereas in this last type of spotlight the height of column is irrelevant.
If it is above the axis it is positive.
If it is below the Axis does negative.
So it is plus or minus or been lost type of graph.
So this is how we create spotlights or mini charts.
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.