How to create Line chart in Excel

Introduction

We use a Line chart to visually see the trends in the data over a period of time in the data. In this tutorial, we will learn steps to add a Line chart using Excel Application for a sample set of data.

Sample Data

Sample rainfall data for the months on a particular year. We will create a line chart for the rainfall data and see the trends over the period.

 

MonthRainfall
Jan1
Feb2
Mar1.5
Apr1
May2.5
Jun1
Jul12
Aug24
Sep44
Oct3
Nov2.5
Dec1

Steps to create a Line chart

  • Launch Excel Application.
  • Select the data in the Excel sheet.
  • Choose Insert >> Insert¬† Line or Area chart.

 

Insert Line chart

 

Select the Type of the Line chart 2d, 3d or Stacked, etc. There are different variations and various styles from the top ribbon.

We can add the chart, resize, add chart title, and drag and drop to a suitable location on the excel sheet.

Screenshot

Rainfall Line chart