# How to make different Line Charts in excel: Explained step by step

#### How to make different Line Charts in excel

What is Line Chart In excel

Line charts is a form of data presentation which helps in presenting data in a simple and meaningful way. Line chart is the simplest and easiest to understand among all charts. It is very helpful in showing some trend over time.

How to use Line Charts in Excel

To use line chart in excel we will go in Insert tab then Insert Line and Area Chart.

What type of line charts are available in excel

There are two type of line charts available in excel:

• 2-D Line Chart
• 3-D Line Chart

2-D Line Chart has 3 different kinds of charts Line, Stacked line and 100% Stacked line with and without markers. Let’s discuss the applicability of these charts.

Line chart is used when we have many data points to plot in a chart or data is in time series or shows trend over time(years, months or days) . To use this chart we will follow the same process Insert >>Insert Line and Area Chart >>Line . A line chart will come like the below image.

We can decorate it as per our requirement. I will be discussing this in another blog post.

Stacked Line shows how parts of a whole changed over time. Here, lines are plotted one at a time, with the height of the last one plotted variable serving as a moving baseline. As such, the fully-stacked height of the topmost line will correspond to the total when summing across all groups. Let us understand this from the below example.

In this example if we see all three variables are showing with their data labels as 45.5%,53.9% and 2.5%.The last variable Cycle is on the top and making baseline at 100% which is sum of all the three variables. As here sum of all variable in all rows are 100% due to which base line is straight otherwise it could vary on point.

100% Stacked Line Chart is a chart in which lines do not overlap because they are cumulative at each point. The lines reach a total of 100% of the axis range at each point. Lines are getting space in the chart as per their share % among all variables. Let us understand this by below example.