Line Chart in Google Sheets: Create, Customize, and Fix

To make a line chart in Google Sheets, select your data, choose Insert > Chart, then pick Line chart in the Chart editor’s Setup tab. Put the x-axis values—usually dates—in the first column and one or more numeric series in the columns beside them; you can then format the chart, labels, and axes in the Customize tab.

What a line chart shows

A line chart connects data points in sequence, making it useful for showing how a value changes over time or another ordered set of categories. For example, a small shop could plot weekly sales, a project team could track tasks completed each month, or a homeowner could chart daily temperatures. The line helps readers notice direction, turning points, and periods of unusual change.

Line charts work best when the horizontal order has meaning. Dates, months, and stages in a process are common examples. They are less suitable when the order is arbitrary, or when the distance between numeric x-values matters: in those cases, a scatter chart may communicate the data more faithfully. A line connects observations; it does not prove that the value changed smoothly between them.

Arrange data before charting

Good source data makes Sheets’ automatic chart setup much more reliable. Put one observation on each row, use a single header row, and keep the x-axis values in the first column. Place each set of measurements in its own column. For instance, a table might have Date in A1, North in B1, and South in C1, followed by one date and the two regions’ sales on each row.

Use clear, distinct column headings. Sheets can use them as series names and chart labels.
Keep each measurement column numeric. Text such as a currency symbol typed into a value cell can interfere with charting; apply number formatting instead.
Enter dates as dates, not as text that merely looks like a date. If the horizontal axis sorts strangely, check the cell values and the spreadsheet’s locale.
Keep units consistent within a series. Mixing dollars and percentages on one scale can make the picture misleading.
Remove unintended blank rows or notes from the selected range. A note below the table can accidentally become part of the chart’s data.

For a simple example, A1:A5 could contain dates and B1:B5 could contain daily visitors. If you want to compare two locations, add a second numeric column with the same dates. A continuous date range is not mandatory, but missing dates and blank measurement cells should be understood before readers interpret the line.

Create a line chart in Google Sheets

In Google Sheets in a web browser, select the table, including its headers, and use Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually in a panel on the right. It may choose a chart type automatically; use the Setup tab’s Chart type menu to select Line chart if the suggested chart is not the one you want.

Select the data range, including the header row and the x-axis column. A tidy table might occupy A1:C13.
Choose Insert > Chart. Review the chart and the Chart editor’s Setup tab.
Under Chart type, choose Line chart. Check that the X-axis field refers to the date or category column.
Check that each intended measurement column appears under Series. If headings or labels are wrong, review the data range and the options for using the first row as headers and the first column as labels.
Close the editor when the chart looks right. Drag the chart to reposition it, or use its handles to resize it.

You can return to the editor by double-clicking the chart. The chart stays connected to its source cells, so changes to values in the selected range can update the display. If new rows are added outside the chart’s current data range, however, they may not appear automatically; edit the range in Setup to include them.

Choose the right line-chart setup

One line is often clearest for a single measure, such as monthly revenue. Multiple lines can compare related series when they share a meaningful scale—for example, weekly orders for three product categories. Each series should have an informative name, and the legend should make it easy to distinguish the lines. Too many series can turn a chart into a tangle; consider splitting the comparison into smaller charts instead.

Google Sheets also offers a Smooth line chart option in its chart-type choices. A smoothed curve can look attractive, but it may imply a shape between observations that the data does not establish. Use a regular line when exact observed points and changes matter, and reserve smoothing for cases where the visual effect will not be mistaken for additional measured detail.

Line and scatter charts are not interchangeable. A standard line chart treats the horizontal dimension as an ordered axis of categories or dates. A scatter chart uses numeric x-values as coordinates, which is useful when observations are irregularly spaced or when the precise numeric distance between them matters. For example, measurements taken at 1, 2, and 10 hours should not necessarily be shown as evenly spaced categories.

Customize titles, labels, and axes

Open the Customize tab in the Chart editor to make the chart easier to read. Under Chart & axis titles, select a title type and enter a chart title or horizontal and vertical axis titles. A useful title explains the measure and period, such as Weekly orders by region, rather than repeating a vague label such as Results.

Use the Legend section to change the legend’s position or presentation. Under Series, options can include data labels and line or point styling; the controls available can depend on the chart type. Data labels are helpful when the chart has only a few points, but labeling every point on a long daily series often creates clutter. Gridlines and ticks can be adjusted in their section of Customize, and the vertical axis can be formatted to suit the values.

For a chart of monthly expenses, a vertical axis that starts at zero makes absolute differences easier to compare. In some situations, a narrower axis range can help reveal small fluctuations, but it also magnifies them visually. If you set axis bounds manually, make that choice clear to readers and avoid implying a larger change than the numbers support. Keep units visible, especially when a value could mean dollars, people, hours, or a percentage.

Compare multiple series responsibly

When the series represent comparable quantities, putting them on one axis makes their levels and trends easier to compare. For example, a chart of monthly sales for two stores can use the same currency scale. Check that the colors and legend names remain distinguishable, including for readers viewing the chart in a small window or printing it without color.

Different units or very different magnitudes are a warning sign. Plotting a percentage and a dollar amount on the same vertical scale can flatten one series. Sheets may provide a right-axis option for a series in some chart configurations, but a secondary axis can make visual comparisons confusing because the two scales differ. If you use one, label both axes plainly and explain why; otherwise, separate charts or a carefully chosen normalized measure may be clearer.

A line chart also does not automatically make a comparison fair. Consider whether the series cover the same dates, whether missing observations are important, and whether each line is based on the same definition. A chart comparing store revenue before and after a location opened, for example, should not make absent months look like zero sales unless zero is truly the intended value.

Fix common line-chart problems

If the chart is blank or has unexpected lines, start in Setup rather than changing colors. Confirm that the data range includes the intended cells, that the series are numeric, and that the date or category column is assigned to the X-axis. Check the first-row-as-headers and first-column-as-labels options. If the data is arranged horizontally, the option to switch rows and columns may help, but reorganizing the table into columns is often easier to maintain.

Dates appear in the wrong order: Sort the source rows by the date column and verify that the entries are recognized as dates. Text dates may sort alphabetically rather than chronologically.
The chart has an unwanted extra line: Inspect the selected range for totals, notes, or a blank column included as a series. Remove those cells from the range or correct the range boundaries.
Headers appear as data: Include the header row and check the setting that treats the first row as headers. If the header was excluded, the series may receive generic names.
Values look too small or too large: Check for mixed units, an unintended percentage format, or an axis scale that does not suit the data. Verify the source cells before relying on the visual.
Recent rows are missing: Edit the chart’s data range in Setup to cover the new rows. A chart based on a fixed range may not include data entered below it.
A line breaks at a missing value: Inspect the source cells to distinguish a truly missing measurement from a zero. Do not replace blanks with zero unless zero is the real observation.

Move, share, or export a chart

A chart can sit on the same sheet as its data or be moved to its own sheet. Use the chart’s three-dot menu to find options for moving it, copying it, or downloading it in an available format. The exact export choices can vary with the current Google Sheets interface. A separate chart sheet can be useful for presenting one large visual, while an embedded chart keeps its underlying table close by.

Sheets is browser-based, so collaborators with access to the spreadsheet can view or edit the chart according to their file permissions. Sharing the spreadsheet is not the same as publishing a chart publicly: review the file’s sharing settings before sending a link, especially if its data is private. When a static image is needed for a document or slide, downloading a chart copy can be convenient, but later edits to the spreadsheet will not update that exported image.

Frequently Asked Questions

How do I make a line chart in Google Sheets?
Select the data, including headings and the x-axis column, then choose Insert > Chart. In the Chart editor’s Setup tab, choose Line chart and confirm the X-axis and Series fields. Use Customize to adjust the title, legend, labels, and axes.

How do I add another line to a Google Sheets chart?
Add the new values in a column beside the existing series, using the same x-axis rows and a clear header. Then edit the chart and expand its data range or add the column under Series in Setup. Confirm that the added values align with the correct dates or categories.

Can I make a line chart with dates?
Yes. Put dates in the first column and measurements in adjacent columns, then assign the date column as the X-axis. Use actual date values rather than text where possible, and sort the rows chronologically if the plotted order is unexpected.

Why is Google Sheets showing the wrong chart?
Sheets may select a chart type based on the chosen range, and it can misread labels or series if the table is irregular. In the Chart editor’s Setup tab, choose Line chart explicitly, check the data range, and verify the header, label, X-axis, and Series settings.

What is the difference between a line chart and a scatter chart?
A line chart emphasizes an ordered sequence, often dates or categories. A scatter chart positions points according to numeric x- and y-values, so the spacing between x-values carries meaning. Use a scatter chart when the actual numeric intervals between observations matter.

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.