In Excel: put time or ordered categories in the first column, values in the next column, select both, then Insert ▸ Line or Area Chart ▸ Line.
Arrange the x-axis labels in the first column and the values in the next column.
Select only the label and value range, excluding totals.
Choose Insert ▸ Line or Area Chart ▸ Line.
Add a chart title, axis labels and markers when the individual points need to be visible.
What this does
A line graph connects values in order, usually across time, so the slope makes direction and change visible. The first column should hold dates, months or ordered categories; the second holds the values to plot. Excel treats each additional numeric column as another line, which is useful for comparing series but messy if totals or helper columns are accidentally selected. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. Treat “create a single line graph in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected chart shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a visual that makes the number obvious at a glance into a method you can reuse, explain, and defend when the workbook leaves your screen.
A worked example
Months Jan through Jun are in A2:A7 and sales 42, 51, 48, 61, 67, 73 are in B2:B7. Select A2:B7, choose Insert ▸ Line Chart, and Excel draws a six-point line rising from 42 to 73. Add markers if individual months matter, and format the vertical axis to start at zero only when that supports the story rather than flattening the change. Line graphs are strong for trends: monthly sales, weekly traffic, running totals, error rates, production output and any metric where readers need to see direction over a sequence. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. The short version of “create a single line graph in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
Common mistakes
- Using a line chart for unordered categories, where a bar chart would compare values more honestly.
- Including a total row, which creates a sudden fake spike at the end.
- Letting Excel treat text dates as categories; convert them to real dates when spacing matters.
- Plotting too many series at once, turning the chart into unreadable crossing lines.
Frequently asked questions
When should I use a line graph?
Use it for ordered data, especially time series, where the change from one point to the next matters.
How do I add a second line?
Place the second value series in another column beside the first, include it in the selected range, and Excel plots it as a separate line.
Line chart or scatter plot?
Use a line chart for ordered categories or dates; use a scatter plot when both axes are numeric measurements.
Other ways people ask this
People reach this page typing “how to make a single line graph in excel” and “how to make single line graph in excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “how to make a single line graph in excel”, “how to make single line graph in excel” all point at the one operation explained on this page, which is why they all lead here.