Line graph

A line graph is a type of chart that displays data points over a continuous interval or time span, connecting them with straight lines. It is particularly useful for illustrating trends, changes, or patterns in data. Line graphs are widely used in various fields, including science, economics, finance, and statistics, to visually represent the relationship between two or more variables.


Consider a line graph tracking the monthly sales of a product over a year. The x-axis would represent the months (January, February, etc.), and the y-axis would represent the sales figures. Each data point on the line would correspond to the sales for a specific month, and the line connecting these points would visually represent the sales trend over the year.


  • Highlight the range of cells containing your data in Google Sheets. Similar to Excel, for X-axis values, select cells in column A (e.g., A1:A30), and for Y-axis values, select cells in column C (e.g., C1:C30).

  • Click on Plot to create a line graph.

  • You can customize your chart using options in the Chart Editor. For example, you can title your chart, adjust the axis labels, and more.

Last updated