How to Make a Line Graph in Google Sheets: A Clear Guide

To make a line graph in Google Sheets, arrange your data in columns with time or category labels first and numeric values beside them, select the range, then choose Insert > Chart. In the Chart editor, open Setup and choose Line chart; use Customize to add titles, adjust axes, and format the lines.

Prepare your data for a line graph

A line graph works best when the horizontal axis shows an ordered sequence, such as dates, months, or stages, and each line represents a set of numeric measurements. Put the axis labels in the first column and the values in neighboring columns. Give each column a clear heading so Sheets can identify series names and display them in the chart legend.

For example, a small store might record monthly sales for two products:

Column A: Month
Column B: Product A sales
Column C: Product B sales

Put headings in row 1, then one month per row below it. Use actual date values if the data represents dates, formatted to display as months if that is easier to read. Consistent units matter: do not mix dollars and units sold in the same series, and avoid putting explanatory text in cells that should contain numbers. A clean, rectangular table is easier for Sheets to interpret than a layout with blank rows, merged cells, or totals inserted between observations.

Line charts are especially useful for showing how a measure changes across an ordered sequence. They can reveal direction, recurring patterns, and differences between related series. They are less suitable for unrelated categories with no natural order; a bar chart may communicate those comparisons more clearly.

Create the chart step by step

Enter the labels and numeric data in adjacent columns, including a header row.
Select the entire data range, including its headings. For example, select A1:C13 if row 1 contains headings and rows 2 through 13 contain twelve months of observations.
Choose Insert > Chart from the menu. Google Sheets inserts a chart and opens the Chart editor, usually on the right side of the browser window.
In the editor’s Setup tab, open the Chart type menu and select Line chart. If Sheets chose a different chart automatically, selecting the desired type changes the existing chart.
Check the data range, X-axis, and Series fields. Confirm that the first column supplies the horizontal labels and that each numeric column appears as a series.
Close the Chart editor when the chart looks right. Sheets saves changes automatically; you can reopen the editor by double-clicking the chart.

If you want to select a range before inserting the chart, highlight only the cells you want represented. If the chart has already been made, you can change its source range in Setup rather than deleting and recreating it. On a small screen, the editor may take up more of the available workspace, but the menu path remains the same in Google Sheets in a web browser.

Check the Chart editor setup

The Setup tab controls what data the chart uses and how Sheets interprets it. The X-axis field should normally contain the ordered labels, such as the dates in column A. The Series section should list the numeric columns to plot. If the wrong column appears on the horizontal axis, use the X-axis field to select the correct range or revise the selected data range.

For a table with headings in the first row and labels in the first column, check the options to use row 1 as headers and column A as labels. Those settings help Sheets use the headings as series names instead of plotting them as data. If your table is arranged differently, those options may need to change. A chart preview updates as you make adjustments, which makes it easier to spot a mistaken range or orientation.

To add another series later, expand the data range or add that column under Series in the editor. To remove a line without deleting its source data, use the series controls in Setup. The chart reflects changes to its source cells, so updating a monthly value in the sheet normally updates the plotted point as well.

Customize titles, lines, and axes

Open the Customize tab in the Chart editor to make the graph easier to understand. Under Chart & axis titles, choose a title type and enter descriptive text. A useful title says what is measured and, when relevant, the period covered. You can also set titles for the horizontal and vertical axes; label units such as dollars, degrees, or kilograms rather than expecting readers to infer them.

The other customization controls let you refine presentation. Chart style includes options for the chart background and font. Legend controls change the legend’s position, which can help when several series are present. Series settings can be applied to an individual line, allowing you to adjust its color and point appearance. Horizontal axis and Vertical axis settings control how labels and values appear, while Gridlines and ticks help readers estimate values from the plotted points.

Keep the design restrained. Choose line colors that are easy to distinguish, use a readable font, and avoid decorative effects that compete with the data. A legend can identify multiple lines, but if there is only one series, a long legend may add little. If labels or dates are crowded, widen the chart, reduce unnecessary labels, or display a shorter date format in the source cells.

Choose the right line chart and axis

The standard Line chart is a good starting point when you want to show values across ordered labels. A Smooth line chart is available in Google Sheets, but smoothing changes how the line is drawn between recorded points; it does not add new measurements or make the underlying data more accurate. For reporting actual observations, the standard line is often the clearest choice, especially if readers need to see where each value was recorded.

A frequent point of confusion is the difference between a line chart and a scatter chart. A line chart treats its horizontal positions as an ordered set of labels or dates. A scatter chart is designed for numeric X and Y values, where the spacing between X values matters. For instance, if one measurement was taken on day 1 and another on day 30, a scatter chart can represent the unequal interval more directly. If the horizontal axis is a list of equally spaced months, a line chart is usually appropriate.

Be thoughtful about the vertical axis. Starting at zero can make differences easier to judge proportionally, while a narrower range can make small changes visible. A narrowed scale can also exaggerate the apparent size of a change, so make the scale clear and avoid using it to imply a stronger difference than the values support.

Plot multiple series and date-based data

To compare related measurements, put each series in its own numeric column and give the columns meaningful headings. For example, a table of monthly temperatures could have a Month column followed by separate columns for City A and City B. Select all three columns when creating the chart. Sheets should plot the two cities as distinct lines and use their headings in the legend. If one line does not appear, check that its cells contain numeric values and that the series range includes them.

Date data needs particular care. Enter dates as date values rather than text that merely looks like a date, and put the rows in chronological order when that is the intended story. If dates appear in an unexpected sequence or as individual categories, check the cell values and the X-axis range. Formatting a date changes how it is displayed, not necessarily the underlying value. For irregularly spaced measurements where elapsed time is important, consider whether a scatter chart better matches the question.

Do not automatically connect across missing observations without considering what a gap means. A blank may mean the value was not recorded, rather than that it was zero. Adding zero would create a real plotted drop and could misrepresent the data. Decide whether to leave the observation blank, explain the gap, or use another treatment consistent with the source data.

Fix common chart problems

The chart is a bar chart or another type: Open the Chart editor, select Setup, and choose Line chart in Chart type.
The months or categories appear as lines: Check that the label column is being used as the X-axis and that the numeric columns are listed under Series. Review the header and label options.
Headings appear as data points: Confirm that the header row is included and that Use row 1 as headers is selected when the first row contains names.
A series is missing: Check the chart’s data range and its Series entry. Also verify that the values are numeric rather than text, and that there are no accidental blank or malformed cells.
The horizontal axis looks out of order: Sort the source rows by the date or sequence column, and verify that date entries are real dates. Sorting a chart’s displayed labels is not a substitute for correcting the source order.
The labels overlap: Enlarge the chart, use shorter labels, or adjust the date display in the source cells. For a long timeline, showing fewer labels can improve readability.
The lines are hard to compare: Give each series a clear name, use distinct colors, and move the legend to a less crowded position. If the series have very different scales, one may appear nearly flat; consider separate charts or an appropriate secondary axis rather than hiding the difference.

When the output still seems wrong, compare a few plotted points with the original cells. This simple check can uncover a range that starts one row too low, an extra total row, or a value stored as text.

Move, copy, and use the finished chart

You can reposition a chart by dragging it on the sheet and resize it using its handles. To place it on a separate chart sheet, open the chart’s three-dot menu and choose Move to own sheet. A chart sheet is useful when you want the visualization to fill its own tab; keeping the chart beside the data is convenient when readers need to inspect both together.

To reuse a chart in another sheet or document, use the chart’s menu options to copy it, or use the browser’s copy and paste commands where supported. Google Sheets also provides download and publishing options through the chart menu, though the available choices and resulting format depend on the option selected. Before sharing a spreadsheet, consider its sharing permissions: anyone who can view the file may be able to see its source data, not only the chart. Use the Share button to review access settings.

For a graph intended for a report or presentation, give it a specific title, explain unusual gaps or scale choices, and include the period and units. A chart is a visual summary, not a replacement for describing what the data measures. The source table should remain understandable to someone who needs to check or update the values later.

Frequently Asked Questions

Can Google Sheets make a line graph with two lines?
Yes. Put each set of values in a separate column, include a heading for each, and select the label column plus both value columns before choosing Insert > Chart. Confirm that both columns appear under Series in Setup.

How do I change a chart from a bar graph to a line graph?
Double-click the chart to open the Chart editor. In Setup, open Chart type and select Line chart. You do not need to rebuild the source table if its labels and values are already arranged correctly.

Can I make a line graph with dates in Google Sheets?
Yes. Put date values in the first column and measurements in adjacent columns, then use the date column as the X-axis. Sort the rows chronologically if that is the intended order, and check that the dates are stored as dates rather than plain text.

How do I add a title to my line graph?
Open the Chart editor, choose Customize, then Chart & axis titles. Select the chart title or an axis title and type the wording you want. Include units or the time period when they help readers understand the graph.

Why does my line graph show the wrong data?
Review the selected data range, X-axis, and Series fields in Setup. Check whether the header and label options match your table, and make sure the plotted cells contain numeric values. A total row or an accidentally included column can also change the result.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.