Google Sheets Line Chart Maker: Create and Format a Chart

Google Sheets has a built-in line chart maker: select your data, choose Insert > Chart, then select Line chart in the Chart editor. You can then adjust the chart title, axes, colors, and series without installing an add-on.

What a line chart in Google Sheets is for

A line chart displays values as points connected by lines. It is especially useful for showing how a measurement changes across an ordered sequence, such as daily website visits, monthly expenses, weekly temperatures, or sales by quarter. The connecting lines help readers notice direction, turning points, and repeated patterns.

In Google Sheets, a chart is linked to cells in the spreadsheet. If you change a value in the selected range, the chart generally updates to reflect it. You can also change the chart’s data range later, so it is not necessary to have a perfect dataset before making a first draft.

A line chart works best when the horizontal order has meaning. Dates, months, elapsed time, or a progression of stages are natural categories. If the horizontal values are measurements that need to be positioned according to their numeric distance—such as height and weight—use a scatter chart instead. A line chart typically treats its horizontal entries as categories, rather than spacing them according to the numeric size of each value.

Prepare the data before making the chart

Good chart setup begins with a tidy table. Put the horizontal-axis labels in the first column and each measured series in its own column. Use one header row to identify the columns, and keep the observations in rows beneath it. For example, a monthly sales table could have Month in column A, Online sales in column B, and Store sales in column C.

Keep each row associated with the correct date or category. Sort date-based data in chronological order if that is the story you want the chart to show; otherwise, Sheets may display the categories in the order they appear in the table. Use consistent units within a series. Mixing dollars and percentages on the same scale can make one series look misleadingly small or large.

Use a clear, nonblank header for every series, such as “Online sales” rather than “Series 1.”
Avoid merged cells, decorative blank rows, and totals inside the body of the chart data.
Store dates as date values when possible, not as text that merely looks like a date.
Keep the values for each category on the same row, so the chart does not pair a value with the wrong label.

For instance, a table with January, February, and March in column A and sales amounts in column B produces a straightforward single-line chart. Add a second numeric column for another store or product, and Sheets can plot it as another series. If your table contains unrelated columns or explanatory notes, select only the relevant rectangular range when creating the chart.

Create a line chart step by step

These instructions are for Google Sheets in a web browser. The chart controls are in the Chart editor, which usually opens in a side panel when you insert a chart.

Select the cells containing the labels, headers, and values you want to chart. Include the header row if you have one.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor.
In the editor’s Setup tab, open the Chart type menu and choose Line chart.
Check the Data range, X-axis, and Series fields. Confirm that the category or date column is the X-axis and that numeric columns appear as series.
If Sheets interpreted the table incorrectly, adjust the range or use the options to use the first row as headers and the first column as labels. The exact options shown depend on the selected range.
Click the chart to move it or resize it, or use the editor’s Customize tab to refine its appearance.

Sheets often guesses the intended arrangement from a clean table, but it is worth checking instead of assuming the first preview is right. If dates appear as a plotted line or the legend contains generic labels, revisit the X-axis and series assignments. A preview that looks odd is usually a data-range or orientation issue rather than a reason to rebuild the spreadsheet.

Customize titles, axes, and visual style

Open Customize in the Chart editor to make a chart easier to read and more suitable for its audience. The available controls vary according to the chart type, but common sections include Chart style, Chart and axis titles, Series, Legend, Horizontal axis, Vertical axis, and Gridlines and ticks.

Under Chart and axis titles, choose the title or axis-title field and enter descriptive wording. A useful title says what is measured and, where helpful, the time period: “Monthly support requests, 2025” is more informative than “Results.” Label the vertical axis with a unit such as dollars, hours, or degrees when the numbers alone are ambiguous.

Under Series, choose a series and adjust its appearance, such as its color or point and line styling. Use distinct, legible colors when comparing multiple lines, and avoid relying on color alone if readers may print the chart in grayscale. The Legend controls its placement or visibility. If the chart has only one line, hiding an unnecessary legend can save space; with several lines, keep a clear legend so readers can identify them.

Gridlines can help readers estimate values, but too many visual guides can clutter a small chart. Consider a restrained number of major gridlines and a vertical-axis scale that makes relevant differences visible. Do not crop the scale simply to exaggerate a small change without making that choice clear; the chart’s framing affects how dramatic a trend appears.

Choose the right line-chart type

Google Sheets offers more than one line-chart style, and the best choice depends on the data. A standard line chart is a sensible starting point for observations recorded in a meaningful sequence. A smooth line chart draws curved transitions between points, which can make a display look softer, but the curve does not add measurements between the points. For data where exact observed values matter, a standard line is often clearer.

Line charts are useful for showing a few related series over the same sequence. They become harder to interpret when many lines overlap, have similar colors, or cross repeatedly. In that situation, consider charting fewer series, splitting the information into separate charts, or using a different visual form suited to the comparison.

Use a scatter chart when both axes represent numeric values and the distance between horizontal values matters. For example, if one observation has an x-value of 2 and another has an x-value of 20, a scatter chart can show the large numeric gap; a category-based line chart may treat the two entries as adjacent positions. A bar chart is often more suitable for comparing a small set of discrete categories that do not represent a sequence.

Plot multiple series and handle missing values

To compare several groups, put each group’s measurements in a separate column and give each column a descriptive header. With months in column A, “North” in column B, and “South” in column C, the chart can show two lines across the same monthly axis. Make sure both series use the same dates and units; otherwise, the visual comparison may not be meaningful.

Missing entries deserve attention. A blank cell is not the same as a measured zero: zero means the measured quantity was actually zero, while a blank usually means no value is available. Entering zero for missing observations can create a sharp drop that is not real. Decide how the gap should be communicated, and check the displayed chart rather than assuming it will convey the missingness in the desired way. If continuity matters, document how absent observations were handled.

When lines overlap, a viewer may mistake them for one series. Distinct colors and descriptive legend names help, but simplifying the comparison is often better than adding more styling. You can also select a series in the Chart editor to adjust its presentation. Avoid adding a secondary axis casually: two scales can make lines look comparable when their units and magnitudes are different.

Fix common chart problems

If the chart is blank or omits values, inspect the selected data range and check that the values are numeric rather than text. Currency symbols or percentage formatting applied through Sheets are generally compatible with numeric cells, while values pasted with extra characters can sometimes be stored as text. Confirm that the series is included and that the intended rows fall inside the range.

Dates show in the wrong order: Check the order of the source rows and sort the data by date if chronological display is intended.
Headers appear as a data point: Include the header row and make sure Sheets recognizes it as labels rather than numeric data.
The wrong column appears on the horizontal axis: In Setup, review the X-axis assignment and the series list.
The chart has an unwanted extra line: Check whether the selected range includes a total, ID column, or unrelated numeric field, and remove it from the range or series.
The trend looks exaggerated: Review the vertical-axis bounds and scale in the customization options, and consider whether the visual framing is fair for the comparison.

If you change the table structure after creating a chart, check whether the chart’s range still covers the intended data. Adding rows immediately below a selected range may not always give you the range you expect, depending on how the chart was configured. The Chart editor lets you review and revise the range directly.

Share, copy, and export a chart

A chart placed in a sheet can be moved and resized like other objects. To reuse it in a document or presentation, use the chart’s three-dot menu for available actions such as copying the chart or downloading it. Download formats offered by Google Sheets can include image or document formats; the menu presents the options available for that chart. You can also copy and paste a chart into another Google app, with the exact linking choices depending on the destination and workflow.

Sharing the spreadsheet gives collaborators access according to the file’s sharing permissions, so review those permissions before distributing a chart that contains private data. If the audience only needs to view the chart, consider whether sharing the whole spreadsheet is appropriate. A downloaded image can be convenient for a report, but it will not update when the source values change; a chart linked to its spreadsheet can remain connected when pasted into supported Google Workspace documents.

Frequently Asked Questions

Is the Google Sheets line chart maker free?
Google Sheets is available at no charge for personal use with a Google account. Some organizational Google Workspace plans are paid, and plan details can vary. Creating a basic line chart does not require a separate chart-making add-on.

How do I make a line chart with two lines?
Put the shared category or date labels in one column and each set of measurements in its own column, with a header above each series. Select the table, choose Insert > Chart, then verify that both numeric columns appear under Series in the Setup tab.

Can Google Sheets make a line chart from dates?
Yes. Place dates in one column and the corresponding numeric values in another, then select both columns and insert a chart. Use real date values where possible, and check that the dates are in the intended order on the horizontal axis.

Why is Google Sheets making a bar chart instead?
Sheets chooses an initial chart type automatically, and its guess may not match your goal. Open the Chart editor, select Setup, and explicitly choose Line chart from the Chart type menu.

Can I make a line chart with separate, unconnected points?
A line chart connects values to show a sequence. If you want points positioned by numeric x- and y-values without connecting lines, choose a scatter chart instead and configure its axes and series in the Chart editor.

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.