How to create a line graph in Google Sheets

Line graphs are easy to make in Google Sheets. Line graphs are the most effective charts to show changes over time, whether over long or short periods. They are easy to analyze and evaluate data and draw comparisons when used as a double-line graph.

How to come up with a simple line chart

1. Select the data set. You can also make a selection of any cell within the dataset

2. Click on the ‘Insert chart’ icon from the toolbar. Alternatively, go to the Insert option in the menu and click on “Chart.”

The following are the steps to change any other chart type into a line chart:

1. Select the Chart you want to change into a line chart

2. Point to the three dots that show at the top-right part of the Chart

3. Click on the ‘Edit chart’ option. A chart editor pane should open.

4. Click on Setup within the chart editor pane

5. Make a Selection of the Line chart option in the chart type drop-down

The Chart will be changed into a line chart

Creating a line graph In Google Sheets with multiple lines

1. Choose the dataset. You can also make a selection of any cell within the dataset

2. Click on the ‘Insert chart’ icon from the toolbar or click on Chart under the insert option from the menu

How to customize a line chart

1. On the computer, open a spreadsheet in Google Sheets.

2. On the Chart you want to change, double click on it

3. At the right, click Customize.

4. Choose the following options:

  • Chart style

It will change how the Chart looks.

  • Chart & axis titles

It will edit or format the title text.

  • Series

It will change line colors and axis location or add error bars, data labels, or trend lines.

  • Legend

It will change the legend position and text.

  • Horizontal axis

It will edit or format axis text or reverse axis order.

  • Vertical axis

It will edit or format axis text, set min or max value, or log scale.

  • Gridlines

It will add and edit the grid

Making a line graph on Google Sheets combined with a column graph/combo chart

1. Select the dataset


2. Click on the ‘Insert chart’ icon from the toolbar. Alternatively, go to the Insert option in the menu and click on Chart.

3. In the chart editor, click on the ‘Chart type’ drop-down within the Setup tab and then click on the Combo chart option.


4. Add a secondary axis and plot profit figures on the secondary axis by:

  • Click on the Chart.
  • Point to the three dots that appear at the top-right part of the Chart.
  • Click on the Edit chart option
  • Click on the Customize option from the chart editor


  • Click on the series option


  • Choose the series you want to put on the secondary axis from the drop-down list.
  • In the ‘Axis’ option drop-down, choose the ‘Right axis’ option

It will add a secondary axis to the combo chart making it complete

Leave a Comment