EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Line Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Line Chart

By Ashwani JaiswalAshwani Jaiswal

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.

Start Your Free Excel Course

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

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

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
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • 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

Let’s Get Started

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

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

Download Line Chart Excel Template

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