Excel's Line with Markers chart, inserted from the Insert tab on a table where each series occupies its own column next to a shared label column, is the built-in way to plot two or more data series on the same axes and the standard answer to how to make a line graph in Excel with multiple lines. For situations where the deliverable is a clean per-series vector image rather than a screenshot of the workbook, the Line Graph Maker converts one column of Label, Value rows into a standalone SVG that can be embedded in slides, documents, or web pages. The same pipeline runs in the current browser without uploading the source rows, so the original Excel data stays on the device. This approach is useful when each series needs to travel through a separate review, such as monthly marketing metrics per product, daily readings from individual sensors, or weekly totals per region. The rest of this article walks through the Excel method for a true multi-line overlay and then shows how the Line Graph Maker produces a clean SVG per series when that is what the publication needs.
Layout Excel Data So Multiple Lines Compare Cleanly
The chart quality starts with how the rows and columns are arranged. Excel treats the leftmost selected column as the x-axis labels and every other selected column as a separate series, so any inconsistency between series columns shows up immediately as a broken or truncated line. The same label must appear at the same row index across every series, the row count must match for each series, and headers should sit on row 1 with no merged cells. When a value is missing for one series in a given period, the cell should either be left truly blank or filled with the literal #N/A so Excel renders a gap rather than a misleading zero.
| Layout | Where the label goes | Where each series goes | Result in Excel |
|---|---|---|---|
| Standard | Column A | Columns B, C, D, ... | One line per column with shared x-axis labels |
| Transposed | Row 1 | Rows 2, 3, 4, ... | Useful only for very short series; harder to read |
| Mixed gaps | Column A | Columns B, C, E (D blank) | Blank column is treated as a series break, not as missing data |
| Single column | Column A | Column B only | One line; a good fit for the Line Graph Maker per-series export |
For most cases the standard layout is the right starting point because it keeps the x-axis interpretation consistent and lets Excel pick sensible axis ticks. Once the layout is right, selecting the data range and inserting a chart is the next step.
Build the Multi-Line Chart in Excel
Excel ships with everything needed to plot several series on one line chart, and the steps below assume the standard column layout described above. The output is a regular Excel chart object that lives inside the workbook, which is the right choice when the reader will keep editing values and wants the chart to update automatically. Save a copy of the workbook before changing chart types, since some operations such as switching between Line and Stacked Line can rewrite the source range reference.
- Click any cell inside the data range, then press Ctrl+A to confirm the selection covers the label column and every series column with no stray rows.
- Open the Insert tab, choose the Line chart group in the Charts ribbon, and pick the first option, Line with Markers, so each data point is visible.
- Right-click the chart, choose Select Data, and verify that the Horizontal (Category) Axis Labels field references the label column while the Legend Entries list shows one entry per series.
- Open the Format Axis pane for the vertical axis, set the Minimum and Maximum to fixed values if the default scale exaggerates a small change, and turn on Major Gridlines for readability.
- Add a chart title and axis titles from the Chart Design > Add Chart Element menu so the chart is self-explanatory when shared.
- Move the chart to its own sheet with Chart Design > Move Chart if the workbook will be reviewed on smaller screens, since embedded charts on dense sheets tend to be resized and lose their labels.
This Excel workflow stays inside the spreadsheet so values and chart stay linked, which is exactly what the question of how to make a line graph in Excel with multiple lines usually calls for. The next section covers the other common case: turning one of those columns into a standalone vector image.
Export Each Series as a Clean SVG With the Line Graph Maker
When the deliverable is a single vector image rather than a live chart object, the Line Graph Maker takes one Label, Value column from Excel and produces a standalone SVG file. The whole pipeline runs in the current browser, so the source rows are not uploaded, and the resulting SVG includes the title, axes, horizontal grid lines, labels, the connecting line, point markers, and accessible point titles. A more detailed walkthrough of the same column-to-SVG workflow is available in Turn Excel's Two Columns Into a Line Graph in Your Browser.
- Type a short chart title at the top, for example Q1-Q4 Sales Region East, and prepare at least two rows per chart in the format Label, Value, where Label is the period name and Value is the number copied from the Excel column. At least two valid points are required, because a single point cannot form a line segment.
- Paste or type those rows into the input area; remember that the final comma on each non-empty line separates the label from the value, so a label such as New York, East is parsed as a label of New York, East followed by its number.
- Click Generate, then inspect the displayed axis range and the row counts; the tool reports invalid rows and rows above the 200-row limit separately beside the result so the source of any skip is explicit.
- Verify the plotted order matches the input order, the title appears at the top, and the axis labels expose the displayed domain before relying on the chart.
- Click Download to save the standalone SVG, then open it in a browser or import it into a document, slide, or design application. Because the file is vector output, it stays sharp when resized or printed.
The SVG output uses a white background and a blue line, which keeps it compatible with most publication pipelines. For brand-specific palettes or accessibility treatments, edit the SVG in any vector editor after export rather than expecting the tool to enforce those choices.
How the Vertical Position Is Calculated
The vertical coordinate of every point follows a fixed linear formula, which is worth knowing when reading or auditing a generated chart. With domain minimum m, domain maximum M, the entered value v, the plot bottom in pixels B, and the plot height in pixels H, the y-coordinate is:
y = B - ((v - m) divided by (M - m)) times H
For a chart with m = 10, M = 50, v = 30, B = 400 pixels, and H = 400 pixels, the calculation becomes y = 400 - ((30 - 10) / (50 - 10)) x 400 = 400 - (20 / 40) x 400 = 400 - 0.5 x 400 = 400 - 200 = 200 pixels from the top of the plot. The same formula is applied to every point, and the same deterministic layout feeds both the preview and the downloaded SVG, so the saved file matches what was reviewed on screen.
When to Keep Excel and When to Switch to SVG
Excel and the Line Graph Maker serve different stages of the same workflow. Excel is the right tool while the data is still being edited, while the user wants a live legend and axis that update with new rows, or while multiple series need to share one chart object for comparison. The Line Graph Maker is the right tool when the goal is a per-series vector image for a slide deck, a printed handout, a brand-controlled template, or a web page that needs a crisp graphic that does not pixelate. It is also useful when each series is reviewed independently, since a standalone SVG file travels through email and document comments without dragging the rest of the workbook along with it.
A practical split is to build the multi-line chart in Excel for analysis, then copy one column at a time into the Line Graph Maker to ship the same data as a clean vector asset per series. This avoids the screenshot quality loss of exporting an Excel chart as an image and keeps the source spreadsheet untouched. For an exact overlay of multiple series in one vector image, a full plotting or design application is still the better fit, since the Line Graph Maker is scoped to a single series per chart.
Limits to Know Before You Share the Chart
A few behaviors of the Line Graph Maker are worth keeping in mind so the published chart matches the source data. The tool processes up to 200 non-empty rows per chart, and additional rows above that limit are skipped and reported separately from malformed rows. The full input is capped at 50,000 UTF-16 code units, and the parser rejects any paste that exceeds that size. Blank lines are ignored, and empty labels, malformed numbers, Infinity, and magnitudes above 1e12 are invalid; the parser accepts positive, negative, zero, decimal, and scientific-notation values but does not add precision beyond what JavaScript double-precision arithmetic already provides. The first valid row is placed at the left edge of the plot and the final valid row at the right edge, with intermediate rows spaced evenly in between, so the horizontal positions are not interpreted as dates or measured x distances.
The vertical axis runs from the smallest entered value to the largest entered value rather than starting at zero, which means the apparent size of a change depends on the displayed domain. When every value is identical, the domain is expanded symmetrically so the line remains visible in the middle instead of dividing by a zero range. Five evenly spaced horizontal reference lines and axis labels expose the displayed domain. A line between points shows sequence and direction only, so it is not evidence of causation, and the tool does not calculate regression, forecast, moving average, confidence interval, statistical significance, error bars, or missing-value interpolation. Long labels can crowd the horizontal axis on narrow screens, so shortening labels or using fewer points improves readability. Editing the title or data clears the generated output and disables the download button until the chart is generated again, which keeps the visible input and visible chart in step.
Because the SVG uses an 800 by 480 viewBox, the preview may scroll horizontally on small devices while the exported file retains a stable aspect ratio. For more advanced rendering features such as logarithmic axes, explicit x coordinates, or categorical color encoding, a full plotting or spreadsheet application is the better fit; the Line Graph Maker is scoped to the simple, ordered, single-series case.
If you're weighing options, Creating Yes or No in Excel Without Volatile RAND covers this in detail.