How to Create a Line Chart in Excel?

Before we learn how to create a well designed line chart in Excel, we must know what is line chart and when we need this.

What is a Line Chart?

A linear graph which shows a series of data points connected by straight lines. Line chart is a graphical object used to represent the data in Excel spreadsheet.

When can we use line chart?

When:

  • You want to show a trend over time like days, months or years. In this case, the time values would be your categories.
  • The order of your categories (i.e.: time values) is most important.

How to create Line chart in Excel

Case Study:

Think you want to compare the monthly sale trends of your products like TV, Mobile and Tablet in a year. A line chart is better for this type of data.

You’ll need some data, of course! Start a new spreadsheet and enter the same data as above picture:

Month Sales Excel Sheet

Now let’s go through the following steps to create a line chart with our created table of product sale:

Step 1: Highlight the whole table that you would like to use for the line chart. In this example, we have selected the range A1:D13.

Highlight the whole table that you would like to use for the line chart

Step 2:  Select the Insert tab from the top of the screen of Excel Interface.

Select the Insert tab from the top of the screen of Excel Interface

Step 3:  Click on Line Chart button from the Charts group.

Step 3: Click on Line Chart button from the Charts group.

Step 4:  Select a chart from the drop down menu of Line chart. In here, we have selected Line with Markers from 2-D Line section as like above picture.

When you hover over each choice of a line from the drop-down menu, it will show you a preview of your data in the highlighted chart format inside the spreadsheet!

Select a chart from the drop down menu of Line chart

Step 5: Now we see the line chart appear in your spreadsheet showing the trend for 3 products. This line chart is representing the trend for Mobile, Tablet and TV. They are showing as different series of data points with 3 different colors for Mobile, Tablet and TV.

This Line chart has 3 parts:

  1. Chart Title
  2. Plot Area
  3. Legend

There are 2 axes In a Line chart. The axis values for each product sales are displayed on the left side of the graph. In the bottom side, it is showing Months.

Now we see the line chart appear in your spreadsheet showing the trend for 3 products

Step 6:  Change the Title of this Line chart by click inside the Chart Title box. Now change the title as Product Sale Trends.

Our line chart is created successfully! Now, Let’s get some TIPS to decorated our created line chart and make this more attractive!

Change the Title of this Line chart by click inside the Chart Title box

Tips 1: How to change the style and background?!

Click on the chart background, then Chart Styles button will be appeared. Using this tool we can change the color of line and also the style of whole background of the line chart. Then click on the Chart Style button to see the styles listed inside the Chart Styles as like above picture. Here we have selected the style which is showing the value inside each vertex point.

How to change the style and background?

Tips 2: How to hide a particular Series and category?!

Click on the chart background, then Chart Filters button will be appeared. It will show the list of category and series of the line chart with Check/Uncheck option. Now If we uncheck January from Category and Mobile from series, then both of them will be disappear from our line chart after click Apply.

How to hide a particular Series and category?

Tips 3: How to style Plot Area using Plot Area properties?!

If you double click on Plot Area, you will get plot area properties on the right side of the excel interface to change the plot line style, background and shape, color and much more.

Task: Same for another elements like Chart title, Legend you will get their properties with huge options when double click on them.

How to style Plot Area using Plot Area properties?!

Tips 4: Change Design?!

Click on the Line Chart then a new Tab group named Chart Tools will be appeared on the upper side of excel Interface like above image. Chart Tools contain 2 tabs named Design and Format. Using Design tab we can change or use any design for our  line chart. In other hand using Format tab we can change inside the line chart like Font style, color and much more.

Change Design?!

Now you are ready to create and design an attractive Line chart in Excel!!…..

Related Tutorials

Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Split Cells in Excel using Text to Column
June 7, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018
5 Powerful Tricks to Format cells in Excel
May 31, 2018
Insert a Picture into a Cell in Excel
May 25, 2018
What is ISFORMULA Function and FORMULATEXT Function
May 21, 2018
How to Use SUBSTITUTE Function
May 21, 2018
Excel Quartile Function in Excel
May 8, 2018
How to use the Excel PERCENTILE function
May 7, 2018
Insert or Type degree symbol in Excel with Autocorrect Feature
May 7, 2018
25% Discount
No prize
All Courses at $200
Almost!
10% Discount
Free Ebook
No Prize
No luck today
Almost!
50% Discount
No prize
80% Discount
Get a chance to boost your knowledge!
Use this coupon code for any course that you wish for. 
Our in-house rules:
  • You can choose any course & redeem coupon
  • If you find any difficulty, mail us on [email protected]
  • Wheel Spin will end soon
  • Coupon code can be applied within 2 days.