In this video we will learn about line charts line charts are often used to block continuous data and
are useful for identifying trends.
For example plodding daily sales as a line chart may enable you to identify sales fluctuations over
time.
Normally the category axis or the or b horizontal axis bottom line chart displays equal intervals.
In this example here for each year I have the contribution to sales of different product.
So this in this first line in the year 1953.
This shirt sales were contributing to forty three point forty three point five percent of the total
it and I have this data for next forty eight years.
Take 2000 so when I plot a line chart of these three products these three data these come as three different
lengths you can identify each data as it is with different color and the color is true is representing
which product is given in this Legion box on the light
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 need this chart.
We will select the water table and will 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.
There is a line just for this table to click on okay.
And this line that is creating 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 religion box below.
If you are not sure that Excel has selected the flight data 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 the edit button.
The city's name is shows 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 cities 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 being correctly.
You can click on this edit button and then selected years range let us click on okay.
Now as told earlier you can change the di da title horizontal axis title.
You can format all these just in the same way we did for by chart.
Now let us look at different types of line charts available.
Let's click on this.
Change our type button you can see we have all these options of line judge the this first one is selected
which is a simple line Jack.
If you go to the next one it just tag line chart so tag line chart is similar to this tag bar chart
the different data series will be stacked one on top of the other so you can see first.
We have this short chart on top of it.
We will have the banks values and on top of that we'll have the others valued.
So this band sees value is giving us these sum of banked plus shared contribution.
So for the year 1953 the band contribution point will be at ninety seven point four percent with the
sum of forty three point five percent plus fifty three point nine percent and the third line which is
the others line will be the sum of all the three so it will be at 200 percent and its contribution to
those two hundred percent.
So the city's tagline next one is hundred percent tagline.
Since our total is hundred percent in this case these two will be exactly same.
In case you have these totals do we not.
Hundred percent.
This represents that Lane will convert only to adults to 100 percent and truly contribution of each
product as a percentage of total.
So as told earlier in budget also it is used to compare the contribution of different product to the
total.
Next comes line with markers.
Let us select this and click on Okay so you can see that for each data point there is 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.
We just constituting this line chart.
Apart from that it is exactly same to the same building.
Jack does that.
It has the markers without identifying the individual reader point the other types of chart types available.
These other two types are the same things that we discussed earlier.
Just that it will have markers with them.
This last one is and is a 3D option of lane 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 3D line judge create.
But even in that example you will see that a 3D line chart doesn't 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 on that point which is you can add since this one has no markers on it.
You can first of all add markers to it to highlight the data point and the second thing you can add
is the data labels.
If you want to highlight the value add each data point you can have data labeled
so if I go to Data labels and hover over the above option you can see for each data point.
The value is noted.
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 fewer data points 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 data point you can actually view the value
there.
Now let us discuss the 3D line chart I'm showing you this does to make a point that it does not make
any sense to draw through the line chart.
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 make us and blame chart you can easily see that this is the trend of population mostly it is increasing
for the certainty and identity and for Delhi in 2005 that a sudden increase in population.
But if I create a 3D chart for this
you can see that even with the grid lanes we are not really sure what are the values of London answered
me 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 3D line chart in any scenario.
It is always preferable to draw a simple 2D line chart.