How to Line Chart Excel

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. For “line chart excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected chart change, and only then apply the same setup to the full sheet. 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 is what makes a visual that makes the number obvious at a glance useful in real work: repeatable, auditable, and not dependent on memory or luck.

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

Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. The short version of “line chart 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