Excel Line Chart With Multiple Series: A Step-by-Step Guide

To create a line chart with multiple series in Excel for Microsoft 365 on Windows, arrange each series in its own column, select the whole data range including the headers, then choose Insert > Insert Line or Area Chart > 2-D Line. Excel plots each selected column as a separate line against the shared category labels in the first column.

How multiple-series line charts work

A line chart compares values across an ordered set of categories, such as months, dates, or stages in a process. Each series is a related set of values represented by its own line. A chart with monthly sales for three products, for example, has one line per product and one shared horizontal axis for the months.

The chart works best when every series uses the same categories in the same order. Excel uses the first column or row of the selected data as category labels and the remaining values as series, depending on the layout it detects. Headers become series names and appear in the legend. Keeping the data in a rectangular table makes that interpretation easier and makes later edits less error-prone.

A line chart is not the same as a scatter chart. A line chart treats its horizontal values as categories, even when labels look numeric. Use a scatter chart when both the horizontal and vertical values are numeric measurements and the spacing between horizontal values matters, such as plotting measurements taken at irregular time intervals.

Arrange the worksheet data first

Put the category labels in the first column and each series in a separate column. Use a header for every series, and keep the category labels consistent across the rows. For example, a simple sales table could have Month, Product A, Product B, and Product C as column headings, followed by one row per month and the values for each product.

Use one header row and one row for each category. Avoid blank rows or columns inside the data block.
Keep each series in the same unit when possible. Comparing dollars with units sold on one scale can make the chart hard to interpret.
Enter actual dates as Excel dates, not text that merely resembles a date, if you want Excel to recognize the time sequence.
Keep the table focused on the values you intend to chart. Notes, subtotals, and grand totals can be mistaken for additional categories or series.

For instance, if column A contains January through June and columns B through D contain three product totals, select A1:D7. The first row supplies the legend names, the first column supplies the month labels, and the six rows beneath the headers provide each line’s values. If the headings are absent, Excel may give the series generic names such as Series 1, which you can fix later.

Create the chart from the selected range

Select the headers and all the data, including the category labels. In the example above, select A1:D7.
Open the Insert tab, choose Insert Line or Area Chart in the Charts group, and select a 2-D Line option. Line with Markers is useful when you want to make individual observations visible; a plain Line chart emphasizes the overall trend.
Excel inserts a chart on the worksheet. Check that the legend contains the intended series names and that the horizontal axis shows the expected categories.
Click the chart title and replace it with a concise description, such as Monthly Sales by Product. Use the Chart Elements button beside the chart to add or remove a legend, axis titles, data labels, or gridlines.

When the chart is selected, Excel displays contextual chart tabs, including Chart Design and Format. The exact placement of controls can vary with window width, but the chart-type and data-selection commands are available from Chart Design. If Excel creates one line per month instead of one line per product, go to Chart Design > Switch Row/Column. That command changes which direction Excel treats as a series; it does not alter the worksheet data.

Add or correct series after insertion

You do not have to rebuild a chart if a series is missing or incorrectly named. Select the chart, choose Chart Design > Select Data, and review the Legend Entries (Series) list. Choose Add to define another series, or select an existing entry and choose Edit. In the Edit Series dialog, specify the series name cell and the range of numeric values. Keep the values aligned with the category labels so each plotted point corresponds to the intended category.

The Horizontal (Category) Axis Labels area in the Select Data Source dialog lets you edit the label range. This is useful if Excel has used row numbers or the wrong column for the horizontal axis. For example, if the month labels are in A2:A7, set that range as the axis labels rather than selecting the data values again. If series and labels are reversed, try Switch Row/Column first; manually editing each range is more appropriate when the source layout is irregular.

You can also add data by extending the source table. If the chart is based on an Excel table, adding a new row or column to the table will generally extend the chart’s data source automatically. For an ordinary cell range, check the chart after adding data; if the new cells are outside its source range, use Chart Design > Select Data to include them. This distinction matters for charts that must grow as new periods are recorded.

Choose a line style and format the chart

Excel offers several 2-D line variations. A plain line is appropriate when the series has many observations and markers would clutter the view. Line with Markers helps readers identify individual data points, particularly when there are only a few categories. Stacked Line and 100% Stacked Line answer different questions: they show how series contribute to a cumulative total or percentage, rather than simply comparing each series’ independent values. Use those options only when that cumulative interpretation is intended.

To change a series’ appearance, select its line and use the Format Data Series pane. Choose colors with enough contrast, and avoid relying on color alone if the chart may be printed in grayscale or read by people with color-vision differences. Different marker shapes or line styles can help distinguish overlapping series. A restrained palette and a clear legend are usually easier to read than a different bright color for every line.

Axis titles can clarify what the values measure and their units. A useful chart might label the vertical axis Revenue in dollars and the horizontal axis Month. Gridlines can help readers estimate values, but too many heavy gridlines compete with the data. Data labels are useful for a small number of points; applying them to every point in a dense chart can make labels collide. For a specific point, select the series and then select that point before adding or formatting a label.

Handle different scales, dates, and missing values

Series with very different magnitudes can make a shared vertical scale misleading. If one series ranges from 0 to 1,000 and another from 0 to 5, the smaller series may appear almost flat. A secondary vertical axis can help when the series measure different units or have substantially different scales: select the relevant series, open Format Data Series, and choose Secondary Axis under Series Options. Add or revise axis titles so readers know which scale belongs to which line.

A secondary axis is not automatically the best fix. It can make two lines appear to move together even when their scales differ, so label both axes clearly and explain the units. If the values represent comparable quantities, consider whether the chart should instead use a common scale or whether separate charts would communicate the comparison more honestly.

For date-based categories, check that the worksheet contains genuine Excel dates and that the labels are in chronological order. If the axis spacing or labeling is unexpected, right-click the horizontal axis, choose Format Axis, and inspect the Axis Options. Excel may use a date axis or a text category axis depending on the data and chart configuration. Blank cells also affect the shape of a line. Select the chart and choose Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed; available choices include gaps, zero values, or connecting data points with a line. Choose the treatment that reflects what a blank means in the source data, rather than implying a value that was never recorded.

Common problems and practical fixes

Only one line appears: Confirm that each series has its own data column or row and that the entire data block was selected. Then inspect Chart Design > Select Data for omitted ranges.
Series names or axis labels are wrong: Include the header and category-label ranges when selecting data, or correct them in the Select Data Source dialog. Switch Row/Column can fix a reversed orientation.
A series stops partway through: Check whether the source cells are blank, contain text instead of numbers, or lie outside the chart’s data range. Decide whether blanks should create gaps, zeros, or connected lines.
The lines are difficult to distinguish: Use clearer colors, markers, or line styles, and make sure the legend names are specific. Consider removing unnecessary series if they do not help answer the chart’s question.
The chart looks crowded: Reduce the number of displayed categories or series, use a wider chart, or remove individual data labels. If exact values matter more than trends, a table may be a better companion or alternative.

For quick recovery after an accidental change, Windows users can press Ctrl+Z; on Mac, use Command+Z. Undo is useful for chart edits, but it is still sensible to save the workbook before making extensive changes. On Excel for Mac, the same basic approach applies through the Insert and chart-design controls, although ribbon placement and dialog layout can differ. In Excel for the web, chart insertion and basic editing are available, but some detailed formatting controls may be arranged differently or be more limited than in the Windows desktop app.

Frequently Asked Questions

How do I add a second line to an existing Excel chart?
Select the chart, choose Chart Design > Select Data > Add, then enter the series name and the range containing its values. Confirm that its values align with the chart’s existing category labels.

Why does Excel show each row as a separate line?
Excel has interpreted rows as series rather than columns, or vice versa. Select the chart and choose Chart Design > Switch Row/Column. If the result is still wrong, verify the selected range and the location of its headers and category labels.

Can I use non-adjacent columns for multiple series?
Yes. On Windows, select the first range and hold Ctrl while selecting additional ranges; on Mac, hold Command. Include the relevant headers and category labels, and check the resulting chart because non-adjacent selections can be interpreted differently depending on the ranges. You can also add each range through Select Data.

How do I show months on the horizontal axis?
Place the month labels in a column or row alongside the values and include them in the selected chart range. If the axis shows numbers or the wrong labels, use Chart Design > Select Data to set the Horizontal (Category) Axis Labels range.

Can one line chart use two vertical axes?
Yes. Select the series that needs a separate scale, open Format Data Series, and assign it to a Secondary Axis. Label both axes clearly and use this sparingly, because different scales can make visual comparisons easy to misread.

Should I choose a line chart or a scatter chart?
Choose a line chart when the horizontal axis represents ordered categories or evenly spaced periods and you want to show a trend. Choose a scatter chart when horizontal values are numeric measurements and their actual intervals must determine the point spacing.

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.