EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Excel Excel Resources Excel Charts Excel Line Chart

Excel Line Chart

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 24, 2023

Line Chart in Excel

Excel Line Chart (Tables of Contents)
  • Line Chart in Excel
  • How to Create a Line Chart in Excel?

Line Chart in Excel

Line Chart is a graph that shows a series of point trends connected by the straight line in excel. Line Chart is the graphical presentation format in excel. By Line Chart, we can plot the graph to see the trend, growth of any product, etc.

Line Chart can be accessed from the Insert menu under the Chart section in excel.

ADVERTISEMENT
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to Create a Line Chart in Excel?

It is very simple and easy to create. Let us now see how to create a Line Chart in Excel with the help of some examples.

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

Example #1

Here we have sales data of some products sold in a random month. Product Type is mentioned in column B, and their sales data are shown in subsequent column C, as shown in the below screenshot.

Line Chart Example 1-1

Let’s create a line chart in the above-shown data. For this, first, select the data table and then go to the Insert menu; under Charts, select Insert Line Chart as shown below.

Insert Line Chart

Once we click on the Insert Line Chart icon as shown in the above screenshot, we will get the drop-down menu of different line chart menu available under it. As we can see below, it has 2D, 3D and more line charts. For learning, choose the first basic line chart as shown in the below screenshot.

Line Chart Example 1-3

Once we click on the basic Line chart as shown in the above screenshot, we will get the line chart of Quantity sold, drawn as below.

Chart of Quantity sold

As we can see, there are some more options available at the right top corner of the Excel Line Chart, by which we can do some more modifications. Let’s see all the available options one by one.

Line Chart Example 1-5

First, click on a cross sign to see more options.
Line Chart Example 1-6

Once we do that, we will get Chart Elements, as shown below. Here, we have already checked some of the elements for an explanation.

Line Chart Example 1-7

  • Axes: These are numbers shown in Y-axis. It represents the range under which data may fall in.
  • Axis Title: Axis Title as it is mentioned beside Axes and bottom of product types in the line chart. We can choose/write any text in this title box. It represents the data type.
  • Chart Title: Chart title is the heading of the whole Chart. Here, it is mentioned as “Quantity Sold.”
  • Data Labels: These are the datum points in the graph, where the line chart points are pointed. Connecting data labels creates line charts in excel. Here, these are 240, 280, 234, and 246.
  • Data Table: Data Table is the table that has data used in creating a line chart.
  • Error Bars: This shows the kind of error and amount of error the data has. These are Standard Error, Standard Deviation, and Percentage mainly.
  • Gridlines: Horizontal thin lines shown in the above chart are Gridlines. Primary Minor Vertical/Horizontal, Primary Major Vertical/Horizontal is the types of gridlines.
  • Legends: Different color lines, different types of the line present different data. These are call Legends.
  • Trendline: This shows the data trend. Here it is shown by a dotted line.

Now, let’s see the Chart Style, which has the icon as shown in the below screenshot. Once we click on it, we will get different styles listed and supported for that selected data and the Line Chart. These styles may change if we choose some other chart type.

Chart Style

If we click on the Color tab circled in the below screenshot, we will see the different color patterns used to have more one-line data to show. This makes the chart more attractive.

Chart Color

Then we have Chart Filters. This is used to filter the data in the chart itself. We can choose one or more categories to get the data trend. As we can select in below, we have chosen laptops and Mobile in the product to get the data trend.

Chart Filters

And the same is getting reflected in Line Chart as well.

Result of Example 1

Example #2

Let’s see one more example of the Line Charts. Now consider the two data sets of a table as shown below.

Line Chart Example 2-1

First, select the data table and go to the Insert menu and click on Recommended Charts as shown below. This is another method of creating Line Charts in excel.

Line Chart Example 2-2

Once we click on it, we will get the possible charts that the present selected data can make. If the recommended chart does not have the Line Chart, click the All Charts tab below.

Line Chart Example 2-3

Now, from the All Chart tab, select Line Chart. Here also, we will get the possible type of line chart that may be created by the current data set in excel. Select one type and click on OK, as shown below.

Line Chart Example 2-4

After that, we will get the Line Chart as shown below, which we name as Sales Trend.

Line Chart Example 2-5

We can decorate the data as discussed in the first example. Also, there is more way of selecting different designs and styles. For this, select the chart first. After selection, Design and Format menu tab becomes active, as shown below. From those, select the Design menu and select under that select and suitable style of chart. Here, we have selected a black color slide to have a classier look.

Line Chart Example 2-6

Result of Example 2

Pros of Line Chart in Excel

  • It gives a great trend projection.
  • We can see the error percentage as well, by which the accuracy of data can be determined.

Cons of Line Chart in Excel

  • It can be used only for trend projection, pulse data projections only.

Things to Remember About Line Chart in Excel

  • Line Chart with a combination of Column Chart gives the best view in excel.
  • Always enable the data labels so that the counts can be seen easily. This helps in the presentation a lot.

Recommended Articles

This has been a guide to Line Chart in Excel. Here we discuss how to create a Line Chart in Excel along with excel examples and a downloadable excel template. You may also look at these suggested articles –

  1. Excel Bubble Chart
  2. Interactive Chart in Excel
  3. Pie Chart in Excel
  4. Line Break in Excel
ADVERTISEMENT
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Line Chart Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Line Chart Excel Template

EDUCBA

डाउनलोड Line Chart Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW