FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

Line Chart Examples

Updated on December 28, 2023
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

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. For example, you can consider the below-given 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 can display lines horizontally that consist of the horizontal X-axis, which is an independent axis because the values in the 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 the vertical Y-axis, which is the dependent axis because the values in the Y-axis will depend on the X-axis. The result is the line that progresses 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 of line charts. They are:

  • Line chart – It shows the trend over time (years, months, days) or other categories. It is used when the order of time or types is important.
  • Line chart with Markers – It is similar to the line chart, but it will highlight data points with markers.
  • Stacked Line chart – This is a line chart where lines of the data points do not get overlapped because they will be cumulative at each point.
  • Stacked Line chart with Markers –  This is similar to the stacked line chart but will highlight data points with markers.
  • 100% Stacked Line chart – It shows the percentage contribution to a whole-time or category.
  • 100% Stacked Line chart with Markers – This is similar to a 100% stacked line chart, but markers will highlight data points.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Excel Line Chart Video Explanation

 

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

Example #1 – Line Chart

Assume that we got the sales data quarterly from Q1-16 to Q3-19. Now, we use a line chart to see the trend in the sales for the given period. So, let us 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 the “Insert tab” as follows:

Line Example 1-1

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

Then we will get the list of line charts available, and we should select the line which will be the first one on 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 sales during certain quarters, which will help management figure out the reason for the fall or rise of their sales numbers during that period.

Example #2 – Line Chart with Markers

As we had seen the line graph in the above example, we could not see the mark of the exact place of data points. Therefore, 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 marked with a red-colored line in the above diagram. 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 us assume that we got the sales data of different segments in the company’s residential market, as shown below. We can use a stacked line chart to show the cumulative sales in a particular month. Let us see how to plot the stacked graph.

Stacked LineExample 3

Select the data that needs to be plotted and go to the “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 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. So in our example for Jan, the affordable segment point on the line shows the sales data of that particular segment. Still, the luxury segment point shows the cumulative of both affordable & luxury segments. Similarly, the super-luxury segment combines affordable, luxury, and super-luxury segments.

Example #4 – Stacked Line Chart with Marker

To 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 one below with the markers:

Stacked Line with Markers Example 4-1

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

Example #5 –  100% Stacked Line Chart

The 100% stacked line chart is similar to the stacked line chart, but the key difference is that the cumulative is based on the values of certain categories. But in the 100% stacked line chart, the cumulative shows in terms of percentage. Let us 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 the “Insert tab,” select the “Line Chart,” and click on “100% Stacked Line Chart,” which is marked in red color as shown above:

And our chart will look like –

100% Stacked Line Example 4-1

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

Example #6 – 100% Stacked Line Chart with Marker

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 one below with the markers:

100% Stacked Line with Marker Example 5-1

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

Example #7 – Using a Line Chart for Comparison

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

LineComparison Example 7

And it will plot the line graph with all the data points below, which we can use for decision-making purposes.

Line Comparison Example 7-1

The above chart shows the different lines for different segments of the houses. We can observe how each segment’s sales fluctuate and intersect the line in any month. We can plot it with a marker and data labels for better understanding and visualization.

Things to Remember About Line Chart Examples

  • Line charts will help us show how different categories stand to each other and can be used cumulatively 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 many data with different time intervals.
  • Line graphs play a key role in the comparison of different categories. It shows the trend of the data very clearly. Also, using 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 article is a guide to Line Chart Examples in Excel. We discuss the top 7 line chart types, practical examples, and a downloadable Excel template. You may also learn more about Excel from the following articles: –

Reader Interactions

Leave a Reply

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