Excel Line Chart With Multiple Lines: How to Create One

To create an Excel line chart with multiple lines, put the shared categories—such as dates—in the first column and each data series in its own column, select the full range, then choose Insert > Insert Line or Area Chart > 2-D Line. Excel creates one line for each value column, using the column headers as series names and the first column as the horizontal axis labels.

How Excel Organizes Multiple Lines

A line chart compares values across an ordered sequence of categories. In a typical worksheet, each row represents one point in time or one category, and each additional value column represents another series. Excel plots the series as separate lines on the same chart so you can compare their direction and relative values.

For example, a monthly sales table might look like this:

Column A: Month
Column B: North region sales
Column C: South region sales
Column D: Online sales

If the headers are in row 1 and the 12 months are in rows 2 through 13, selecting A1:D13 and inserting a line chart produces three lines. January through December appear along the horizontal axis; sales appear on the vertical axis. The header text identifies each line in the legend.

This layout is often called a wide or series-in-columns layout. It is convenient when every series shares the same categories. If the data is arranged with series in rows instead, Excel may plot each row as a line. You can change that interpretation after creating the chart.

Create a Line Chart from a Data Range

In Excel for Microsoft 365 on Windows, use these steps:

Arrange the data in a rectangular range, with a heading for every series and a category label for every row. Avoid blank header cells.
Select the range, including its headings and category labels. For the example above, select A1:D13.
Open the Insert tab, select Insert Line or Area Chart in the Charts group, and choose a 2-D Line option. For a straightforward comparison, begin with Line rather than a stacked or 3-D variation.
Check that the chart shows the expected number of lines, categories, and legend entries. If Excel assigned the rows and columns incorrectly, select the chart and choose Chart Design > Switch Row/Column.
Give the chart a useful title and, when needed, label the axes. Use Chart Design > Add Chart Element to add a chart title, axis titles, or a legend.

Excel normally recognizes the top row as series names and the first column as category labels when the selection includes both. If those cells are missing or ambiguous, it may use generic names such as Series 1 or plot the labels as data. Including clear headers in the selection reduces cleanup.

In Excel for Mac, the chart command is also on the Insert tab; select the data and use the line chart control to choose a 2-D Line chart. The ribbon layout can differ slightly by release. Excel for the web also supports inserting line charts from selected data, although some formatting controls and chart options may differ from the Windows desktop app.

Add Another Line to an Existing Chart

You do not have to recreate a chart every time you add a data series. If the new series is in a neighboring column and shares the same categories, one straightforward approach is to expand the chart’s source range. Select the chart, then drag the colored outline around its source data to include the new column, if the outline is visible. Alternatively, select Chart Design > Select Data and adjust the chart data range.

To add a series through the dialog, select the chart and choose Chart Design > Select Data. Under Legend Entries (Series), choose Add. In the Edit Series dialog, enter or select the series name and the range of values, then confirm. Make sure the values line up with the chart’s existing category labels; a series with a different number or order of values can be misleading.

If the new data is not adjacent, the Select Data dialog is usually the clearer choice. You can select the name and value ranges separately, then inspect the Horizontal (Category) Axis Labels area to verify the categories. When rows and columns are reversed, use Switch Row/Column and check the result rather than assuming Excel has interpreted the range as intended.

Choose the Right Line Chart Style

A standard 2-D Line chart connects each observation to the next and is a sensible starting point for values recorded at regular intervals, such as monthly costs or daily temperatures. Markers can help readers see the individual observations, especially when there are only a few points. A Line with Markers chart adds a marker at each data point; with many points, markers can overlap and make the graphic busy.

Excel also offers stacked line charts and 100% stacked line charts. A stacked line chart accumulates series values, so the height of a later line reflects its values plus the values below it. A 100% stacked line chart shows each series as a share of the total at each category. These charts answer different questions from an ordinary line chart: they emphasize combined totals or proportions, not the independent value of each series. Do not choose one simply because it looks more dramatic.

For comparisons involving several series, avoid 3-D effects and unnecessary decoration. They can make values harder to compare accurately. Use a title that states what is measured and over what period, such as “Monthly Sales by Region, 2025,” and keep units clear in an axis title or number format.

Prepare Data and the Category Axis

Line charts work best when the horizontal categories have a meaningful order. Months, dates, stages, and ordered rating levels are common examples. Alphabetical product names can also be plotted, but a line connecting unrelated items may imply a progression that does not exist. In that case, a column or bar chart may communicate the comparison more honestly.

For dates, use actual Excel date values where possible and apply a date display format. Text that merely looks like a date may be treated as a text category, which can affect spacing and sorting. Sort the source data into the intended sequence before charting; the line follows the order of the worksheet rows, not necessarily chronological order. If you later sort the table, review the chart to ensure the intended order remains.

Keep the data table consistent: one header row, one category per row, and numeric values in the series columns. Avoid inserting subtotal rows into the middle of the data, since they can become extra plotted points. If some values are unknown, leaving a cell blank is different from entering zero. A zero is a real plotted value and can pull the line down to the axis.

Make Several Lines Easy to Read

More lines do not always make a chart more informative. Similar colors, crossing lines, and a long legend can make a crowded chart difficult to interpret. Use a distinct color for each series, keep the legend in a location that does not obscure the plot, and use direct labels only if they remain readable. A title and axis units give readers context before they inspect individual lines.

When values have very different magnitudes, smaller series may appear almost flat beside a much larger one. First check whether the values use the same units and whether a line chart is appropriate. If the scales genuinely differ, a secondary vertical axis may help, but it can also encourage inaccurate visual comparisons because the two axes have different scales. Use it only when the chart clearly labels both units and the relationship is important. In some cases, separate charts or an indexed view provide a clearer comparison.

Consider the audience and the number of observations. A chart with three annual trends may be easy to follow; a chart with dozens of products and hundreds of dates may not be. Filtering the source table, using separate charts, or summarizing the data can make the comparison more useful. If your data is an Excel table, adding rows to the table can make the source range easier to maintain, but verify that the chart includes new data as expected.

Fix Common Multiple-Line Chart Problems

Only one line appears: Check that every intended series is in a separate value column and that the selected chart range includes those columns. Use Chart Design > Select Data to inspect the listed series.
Months or labels appear as lines: Excel may have interpreted rows as series. Select the chart and choose Chart Design > Switch Row/Column, then check the legend and axis.
The legend says Series 1: Include the header row in the chart range or edit the series name in Select Data. A clear header is more useful than a generic label.
The horizontal axis shows 1, 2, 3: The category label range may not have been included. In Select Data, check Horizontal (Category) Axis Labels and select the intended cells.
A line drops to zero unexpectedly: Look for zeros, formula results of zero, or incorrectly converted blanks in the source data. A zero is plotted as a value, not treated as missing.
The lines look flat or compressed: Check for a much larger value in one series, a mistaken unit, or an unsuitable axis scale. Do not change the scale just to make a small variation look large without making that choice clear.

For gaps caused by genuinely missing observations, select the chart and open Chart Design > Select Data, then choose Hidden and Empty Cells. The available options determine whether empty cells appear as gaps, zero values, or connected points, depending on the chart and Excel version. Check the preview and use the option that accurately represents what is known; connecting across a missing period can imply data that was never recorded.

Line Chart or Scatter Chart?

A line chart treats the horizontal axis as categories in sequence. The spacing between category labels is generally uniform, even if the underlying dates are unevenly spaced. This is appropriate for many monthly reports, where the key question is how a value changes from one period to the next.

An XY (Scatter) chart uses numeric values on both axes and positions points according to their actual x-values. Choose a scatter chart when the horizontal values are measurements, elapsed times, or dates with meaningful and uneven intervals. For example, readings taken after 1, 2, and 10 hours should not necessarily be spaced like three equally separated categories. A scatter chart can also connect points with straight lines when you want to show a relationship or progression between numeric x-values.

The choice is not simply about whether the data has dates. It depends on whether equal spacing by category or proportional spacing by numeric x-value best represents the question. If the timing between observations matters, a scatter chart is often the more faithful representation.

Frequently Asked Questions

How many lines can an Excel line chart have?
Excel can plot multiple series in one chart, but there is no useful universal number for readability. The practical limit depends on how similar the lines are, how many points they contain, and the size of the chart. If viewers cannot distinguish the series, split the chart or reduce the number shown.

How do I change which line is which?
Select the chart and choose Chart Design > Select Data. You can edit a series name or its value range, and you can change the series order in the list. The order can affect the legend and, in stacked charts, the way values accumulate.

Can I add a line from data that is not next to the chart data?
Yes. Use Chart Design > Select Data > Add, then select the series name and values in the Edit Series dialog. Confirm that the values correspond to the chart’s existing category labels.

Why does Excel connect points across a blank cell?
The chart’s empty-cell setting may be set to connect data points. Open Chart Design > Select Data > Hidden and Empty Cells and choose how gaps should appear. A blank means missing information; use a zero only when zero is the actual value.

Can a line chart show different units, such as dollars and percentages?
It can use a secondary vertical axis, but mixing units may make visual comparisons confusing. Label both axes clearly and consider separate charts if the goal is to compare trends rather than relate two different measurements.

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.