How to Make a Line Graph in Google Sheets

Create a line chart directly in Google Sheets, then reuse the data in your browser.

Prepare the columns

Use Week and Visitors as headers. Add Week 1, Week 2 and Week 3 with values of 240, 310 and 290.

Create and customize the chart

Select the two columns, including the heading row.

  1. Choose Insert, then Chart.
  2. In the Chart editor under Setup, select Line chart. Check that Week is the X axis and Visitors is the series.
  3. In Customize, add a descriptive title and label the vertical axis with the unit.

Reopen the data in MakeLineGraph

Copy the cells from Sheets and paste them in the editor. Review the headers and series, then apply and choose PNG, SVG or PDF to download.

Open the editor