Line Chart Examples

Examples of Line Chart in Excel

The line chart is a graphical representation of data that contains a series of data points with a line. These types of charts are used to visualize the data over time. You can consider the below-given examples of Line Chart In ExcelLine Chart In ExcelLine Graphs/Charts in Excels are visuals to track trends or show changes over a given period & they are pretty helpful for forecasting data. They may include 1 line for a single data set or multiple lines to compare different data sets. read more.

Line charts will display lines going horizontally that consists of the horizontal x-axis, which is independent axis because the values in x-axis do not depend on anything, typically it would be time on the x-axis as it continues to move forward irrespective of anything) and vertical y-axis, which is dependent axis because the values in y-axis will depend on x-axis and the result is the line that progress horizontally.

Line Chart Examples

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Line Chart Examples (wallstreetmojo.com)

Different Types of Line Charts with Examples

There are different types in Line charts and they are:

  • Line chart – This chart shows the trend over time (years, months, days) or different categories. This is basically used when the order of time or categories are important.
  • Line chart with Markers – This is similar to the Line chart but data points will be highlighted with markers.
  • Stacked Line chart – This is a type of line chart where lines of the data points don’t get overlapped because they will be cumulative at each point.
  • Stacked Line chart with Markers – This is similar to the Stacked Line chart but data points will be highlighted with markers.
  • 100% Stacked Line chart – This chart shows the percentage contribution to a whole-time or category.
  • 100% Stacked Line chart with Markers – This is similar to 100% Stacked Line chart but data points will be highlighted with markers.

Let’s discuss the types of different line charts with examples as below:

Example #1 – Line Chart

Assume that we got the sales data on a quarterly basis from Q1-16 to Q3-19. Now we use a Line chart to see the trend in the sales for the given period. Let’s plot the line chart for the given data as follows:

LineExample 1

First, we should select the data that needs to be plotted and then go to “insert tab” as follows:

Line Example 1-1

As seen in the above picture we got an option of line charts which need to be selected.

Then we will get the list of line charts available and we should select the line which will be the 1st one of the list as we are plotting a simple line graph for the data.

Line Example 1-2

As soon as we select the first type of line graph which is squared with red color in the above image we will get the graph plotted as below:

Line Example 1-3

The above graph shows the trend in sales for the given period. We can observe that there are fluctuations in terms of sales during certain quarters and this will help management to figure out what was the reason during that period for fall or rise of their sales numbers.

Example #2 – Line Chart with Markers

As we had seen the line graph in the above example but we couldn’t able to see the mark of the exact place of data points. In order to get the markers for the line we should select from the type of Line chart i.e. Line with Markers as shown below:

Line with MarkerExample 2

Select the graph type with markers which is marked with a red colored line in the above diagram and you will get the line chart with markers plotted for the given data points as follows:

Line with MarkerExample 2-1

Now we can see the markers for the data points. It will give better visualization to note the data points and we also can use “data labels” from the options of a line chart to showcase the data points on the graph.

Example #3 – Stacked Line Chart

Let’s assume that we got the sales data of different segments in the residential market of the company as shown below. We can use a stacked line chart to show the cumulative of sales in a particular month. Let’s see how to plot the stacked graph.

Stacked LineExample 3

Select the data that needs to be plotted and go to “insert tab” and select the line chart and click on “Stacked Line chart” which is marked in a red-colored as shown below:

Stacked LineExample 3-1

Now we can see the data in stacked form plotted in the graph as below:

Stacked LineExample 3-2

We can observe the lines are not getting overlapped because the stacked graph gives us the cumulative at each point. In our example for the month of Jan, the affordable segment point on the line is showing the sales data of that particular segment but Luxury segment point is showing the cumulative of both affordable & luxury segments and similarly, the super-luxury segment is showing the cumulative of affordable, luxury and super luxury segments together.

Example #4 – Stacked Line Chart with Marker

In order get the mark on the data points for the stacked line graph we can use the stacked line with marker chart type as below:

Stacked Line with Markers Example 4

And our chart will look like the below with the markers:

Stacked Line with Markers Example 4-1

This type of chart is used for better visualization of the data points on the graph. We can also use data labels to show the data values on the markers as well.

Example #5 –  100% Stacked Line Chart

100% stacked line chart is similar to stacked line chart but the key difference is in the stacked chart the cumulative is based on the values of certain categories but in 100% stacked line chart the cumulative shows in terms of percentage. Let’s see how to plot the 100% stacked line chart and also how it looks:

100% StackedLine Example 4

Select the data that needs to be plotted and go to “insert tab” and select the line chart and click on “100% Stacked Line chart” which is marked in a red colored as shown above:

And our chart will look like –

100% Stacked Line Example 4-1

From the above graph, we can observe the data points are in terms of cumulative percentage. For the month of Jan the affordable segment contributed 30% of total segment sales, both affordable & luxury segment contributed 68% of the total segment sales and affordable, luxury & super luxury segments together show 100% which is the entire sales in the month of Jan.

Example #6 – 100% Stacked Line Chart with Marker

In order to get the mark on the data points for the 100% stacked line graph we can use the 100% stacked line with marker chart type as below:

100% StackedLine Example 4-1

And our chart will look like the below with the markers:

100% Stacked Line with Marker Example 5-1

This type of chart is used for better visualization of the data points on the graph. We can also use data labels to show the data values on the markers as well.

Example #7 – Using a Line Chart for Comparison

Let’s take the data of residential housing segment that discussed in previous examples and plot the line graph for the entire data as below:

LineComparison Example 7

And the line graph with all data points will be plotted as below which can be used for decision making purpose.

Line Comparison Example 7-1

The above chart shows the different lines for different segments of the houses. We can observe how the sales of each segment are fluctuating and also can observe the line getting intersect in any months. This can be plotted with a marker as well with data labels for better understanding and visualization.

Things to Remember About Line Chart Examples

  • Line charts will help us to show how different categories stand to each other and also can use cumulative if the sum of all categories is important for decision making by plotting the stacked or 100% stacked line charts.
  • Line charts will perform exceptionally for a huge number of data with different time intervals.
  • Line graphs play a key role in comparison of different categories as it shows the trend of the data very clearly and also usage of markers and labeling the data will help for better visualization.

You can download this Line Chart Examples Excel template here – Line Chart Examples Excel Template

Recommended Articles

This has been a guide to Line Chart Examples in Excel. Here we discuss Top 7 types of line charts along with practical examples and downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *