Docs · guide

How to make a line graph in Google Sheets, and fix the scale

By Alberto Gulotta · Updated 23 September 2026 · 13 min read

Select the cells, Insert › Chart, and change the type under Setup if Sheets guessed something else. That is how to make a line graph in google sheets, and it is genuinely all there is to the making. What follows is the two things that go wrong afterwards, both of which Google documents and nobody quotes.

Google is direct about what the chart is for: “Use a line chart when you want to find trends in data over time. For example, get trends in sales or profit margins each month, quarter, or year.” Over time is the operative phrase. A line joins its points, and joining says the thing between them moved continuously from one to the other — which is true of months and false of, say, four departments.

1. Lay the data out the way the chart reads it. Google: labels in the first column “show up on the horizontal axis”, the first row becomes “labels in the legend”, and “each row represents a different line in the chart”.
2. Select the cells you want to include in your chart. Labels included — they are what the axis and the legend are made of.
3. Click Insert, then Chart. Sheets draws something immediately; it is a guess, not a decision.
4. Double-click the chart, open Setup, and set Chart type to Line. Google’s steps are to click the Down arrow beside Chart type, then “choose a chart from the list”.
5. If a line is flat, go to Customize and give it its own axis. Under Series, pick the series, then change its axis location. That is the setting that rescues two series with very different sizes, and it is one tab away from where the chart was made.

Google has since made this a chart type of its own. The Workspace release notes for combo charts describe exactly this problem and name the answer: the new types include a “Clustered Column - Line on Secondary Axis”, added so that people can visualise “complex dataset visualization with different scales and metrics without requiring manual re-plotting”. If both series are worth seeing and one of them is ten times the other, that is the shape.

And a line is not always the honest shape either. North Carolina State University’s graphing guide separates the two cases in one sentence: a line graph joins the points, and “the line segment that connects two points on the graph expresses a slope”; a scatter plot exists for when “the individual points should not be connected directly together with a line”. If nothing happened between your measurements, the line is claiming something you did not measure.

Once the scales are sorted, the remaining line-chart decision is how many lines. Sheets will draw as many as your range has columns, and a chart with eight lines is unreadable: the legend becomes a colour-matching exercise, and any line that matters is lost among the ones that do not. Three or four is usually the practical limit. If you need eight, what you have is eight small charts sharing an axis, not one chart.

What lives under Customize. Double-click the chart and the second tab holds chart style, titles, series, legend, both axes and gridlines. Two entries are worth knowing before you go looking. Under Vertical axis you can “set min or max value, or log scale” — and unlike a bar chart, a line chart may legitimately start above zero, because a line encodes position rather than length. Cutting the axis to show detail in a narrow range is a reasonable thing to do, provided the axis is labelled so a reader can see you did it.

The log scale in the same menu is not a formatting choice. It changes what equal vertical distances mean — on a logarithmic axis they represent equal multiplication rather than equal addition. That is the right tool for something growing by percentages over a long period, and a thoroughly misleading one for anything else, because a reader who has not noticed the axis will read the slope in the ordinary way.

The description of what a line chart is for, the data layout rules, the combo chart and the Customize options above are quoted from Google’s own Docs Editors documentation, read on 22 August 2026 and listed below. The observation about the mismatch between that page and its example, and the advice on line counts and log scales, are ours.

Not covered here. It will not stop at Insert › Chart. The making takes a sentence; what goes wrong afterwards takes the page.

It will not repeat a line from the documentation that its own example contradicts. The mismatch is pointed out so you can check it yourself.

And it will not treat a log scale as a formatting option. It changes what the picture means. What holds instead is simple: what the chart is for and the combo chart route are Google’s own wording, including the line its own example contradicts.