In this video, we will learn about lifeguards Lichaj are often used to block continuous data and are
useful for identifying trends.
For example, flooding daily sales as a lifeguard may enable you to identify sales fluctuations over
time.
Normally, the category axis or the or the horizontal axis or a line chart displays equal intervals.
In this example here, for each year, I have the contribution to sales of different products.
So this in this first line in the year 1953, the short sales were contributing to forty three point
forty three point five percent of the total sales.
And I have this data for next.
Forty eight years, 2000.
So when I plot a line chart of these three products, these three datasets come as three different lines,
you can identify each dataset with different color and color.
It is representing which product is given in this little box on the right.
On the x axis, which is the horizontal axis, you can see that I have equally spaced interval of time,
which is two years.
Now, let us learn how to plot this line chart.
I did this chart.
We will select the whole table and we'll go to insert menu.
And this is the icon for line chart.
You can see there are a number of options here.
Since Excel can automatically identify X and Y values, we can use the recommended chart option, which
I told you is the one click method you can see.
Here's the line for this table.
Click on.
Okay.
And this line is created.
What we need to do a lot of things.
We need to do the job title.
We need to give the Y axis title and we can change the positioning of this login box below.
If you are not sure that Xolo selected the right, you can confirm by again going to the selected option.
You can click on this and you can see that in the legend you have showed you can click on this edit
button.
The city's name is Schertz, which is great, and the city's values are from C six to C 53, which is
also correct.
So you can check for all other series also.
And if it is okay, then you can use it on the horizontal axis.
We should have years from 1953 to 2000.
Excel automatically picked them correctly in case it was not built correctly.
You can click on the edit button and then select the year range and let us click on OK.
Now, as told earlier, you can change the title title, horizontal axis title.
You can format all these just in the same way we did for budget.
Now let us look at the different types of line chart available.
Let's click on this change time button.
You can see we have all these options.
Alinejad the first one is selected, which is a simple line chart.
If you go to the next one, it does that line chart.
So its tag line chart is similar to this tag budget.
The different datasets will be tied one on top of the other.
So you can see first we have this short chart.
On top of it, we will have the banked values and on top of that we will have the others values.
So this band sales value is giving us these some of times, plus shared contribution.
So for the year 1953, the band contribution point will be at ninety seven point four percent.
Which is some of forty three point five percent plus fifty three point nine percent, and the third
line, which is the others lane, will be the sum of all the three.
So it will be a 100 percent contribution to those 200 percent.
So this is tagline next, one hundred percent tagline since are totally 100 percent in this case, these
two will be exactly the same in case you have the total to be not 100 percent.
This represents that line will convert only totals to one hundred percent and the contribution of each
product as a percentage of total.
So as told earlier in budget also, it used to compare the contribution of different products to the
total.
Next comes line with Marko's.
Let us select this and click on.
OK, so you can see that for each data point there's a circle mark on the glove.
This is highlighting that data point.
If you have fewer number of points, you can use this to highlight the data point, which is constituting
this line chart.
Apart from that, it is exactly the same to this.
And Plainchant does that.
It has the markers which are identifying the individual data point, the other types of chart types
available.
These other two times are the same things that we discussed earlier, just that it will have markers
with them.
This last one is there is a 3D option of line, which doesn't really make sense.
You can click on it to see what it creates.
It doesn't really make any sense.
I use a different dataset to show the change that that red line chart create.
But even in that example, you will see that a 3D printer does not really make any sense when you're
trying to convey a message using a chart.
Now, let us create that simple one only I want to tell you one other point, which is you can add,
since this one has no markers on it, you can, first of all, add to it to highlight the data point.
And the second thing you can add is the data levels.
If you want to highlight the value at each data point, you can have data labeled.
So if I go to the labels and hover over the above option, you can see for each data point the value
is order.
Since it has a lot of data point, the chart is getting cluttered and it is not looking good at all.
But if you have your data point and you want to highlight the exact value at each individual point,
it is recommended that you use a data label so that at each point you can actually view the value there.
Now let us discuss the treaty line chart I'm showing you.
This does to make a point that it does not make any sense to draw the line.
So here's a sample data of population in each of the three cities in different years if I make a line
chart of this.
If I may, because in Blanchard, you can easily see that this is the trend of population, mostly it
is increasing for the certainty and identity and for delay in 2005 that a sudden increase in population.
But if I create a three day chart for this.
You can see that even with the grid lines, we are not really sure what are the values of London and
certainly in terms of population.
So instead of a graph, it is looking more like an optical illusion.
That's why I never recommend to draw a 3-D line chart in any scenario.
It is always preferable to draw a sample to the line chart.