Excel Line Chart with Two Lines: Setup, Labels, and Fixes

To make an Excel line chart with two lines, arrange the shared category labels in one column and each data series in its own column, select the full range including headers, then choose Insert > Insert Line or Area Chart > 2-D Line. Excel plots each value column as a separate line; use Chart Design > Select Data if the chart does not show the two series you expect.

What a two-line chart shows

An Excel line chart displays one or more data series across a sequence of categories, such as months, dates, or product stages. Each series becomes a separate line, and each point represents a value associated with one category. A two-line chart is useful when you want to compare two related trends on the same horizontal and vertical scales—for example, monthly sales for two stores or actual results alongside a target.

The lines are not a special chart type that must be created separately. Excel builds a standard line chart from the selected data and treats each eligible series as a line. A chart can contain more than two series, but adding more may make comparisons harder, especially when the lines overlap or use similar colors.

A line chart is most useful when the order of the categories matters. The spacing between categories is generally treated as uniform, so January and February sit next to each other just as March and April do, even if the underlying dates are not equally far apart. If the actual spacing between numeric or date values matters, an XY scatter chart may be a better choice.

Arrange the worksheet data

For a straightforward chart, put the category labels in the first column and put the two series in the next two columns. Use the top row for series names. For example, a monthly sales table could look like this:

Column A: Month
Column B: Store North
Column C: Store South
Rows 2 through 13: the months and each store’s values

Keep each row aligned: the two values in a row should belong to the same month. Include a single header row and avoid merged cells in the chart range. Clear headings help Excel identify which values are series names and which values are category labels. You can select the entire table, including the headings, so the chart legend can use the store names automatically.

For a small example, place Month, Store North, and Store South in A1:C1, followed by April and the two April values in row 2, May and its values in row 3, and so on. Selecting A1:C5 would chart the four data rows under those headers. The category labels would come from column A, while columns B and C would form the two lines.

Create the chart in Excel for Microsoft 365

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

Click a cell in the data table, or select the whole range including the headings and category labels.
Open the Insert tab.
Choose Insert Line or Area Chart in the Charts group.
Under 2-D Line, choose Line for plain lines or Line with Markers if you also want a visible symbol at each data point.
Use the chart title, legend, and axis labels to make the comparison understandable.

If you selected a cell inside a continuous table, Excel may identify the surrounding data automatically. Check the result rather than assuming it selected the intended range. If the chart is blank, has unexpected lines, or uses the wrong labels, select the chart and open Chart Design > Select Data. The Select Data Source dialog lets you inspect the chart’s data range, series, and horizontal category labels.

Excel for Mac has a similar Insert-tab chart workflow, although the ribbon layout and some dialog details can differ by release. In Excel for the web, chart insertion and basic formatting are available, but some advanced chart controls may be arranged differently or be more limited than in the desktop app.

Check that both lines use the right data

A correct two-line chart usually has three essential parts: one set of category labels, one series for the first line, and one series for the second line. In Chart Design > Select Data, review the Legend Entries (Series) list. It should contain the two intended names. Select a series and choose Edit to check its series name and values if it is pointing at the wrong cells.

Also inspect the Horizontal (Category) Axis Labels area. Those labels should point to the category column, such as the months in A2:A13, not to either store’s values. If the chart has two lines but the legend shows generic names such as Series 1 and Series 2, the header cells may not have been included in the selected range. Add or correct the series names through Select Data, or expand the chart range to include the headers.

If Excel has treated rows as series when you intended columns to be series, select the chart and choose Chart Design > Switch Row/Column. This is especially useful when the table is arranged with series names down the first column and categories across the top row. The right orientation is the one that produces the intended two series and category sequence; neither layout is inherently wrong.

Format the lines and labels for readability

Two lines should be easy to tell apart without making the chart visually busy. Click a line to select its series, then use the Format Data Series pane or the chart formatting controls to change its color, width, or marker style. Give the lines distinct colors with good contrast, and consider using markers if points need to be read individually. A solid line and a dashed line can also help distinguish series when the chart may be printed in grayscale.

Add a useful title by clicking the chart title and replacing the placeholder with a description such as Monthly Sales: North and South Stores. A legend is valuable when the series names are not obvious from the title. If the legend takes up space or the lines are only two and clearly labeled elsewhere, you can remove it, but make sure readers can still identify each series.

Axis titles are helpful when the units are not self-evident. For example, label the vertical axis Revenue (thousands of dollars) rather than leaving a reader to guess whether the values represent dollars, thousands, or units sold. In Excel, select the chart and use Chart Design > Add Chart Element to add or position elements such as axis titles, gridlines, and a legend. Keep gridlines subtle so they support value reading without competing with the lines.

Dates, missing values, and axis choices

When the horizontal labels are dates, confirm that Excel recognizes the cells as dates rather than unrelated text strings. A line chart can show the labels in order, but text that looks like a date may not behave as a true date value. If the date spacing is uneven and the gaps matter—for example, measurements taken on the 1st, 2nd, and 20th of a month—an XY scatter chart with lines represents the spacing more faithfully than a category-based line chart.

For a line chart, you can adjust the horizontal axis by right-clicking it and choosing Format Axis. Depending on the data and chart, Axis Options may let you choose a Date axis or a Text axis. A date axis can use calendar spacing; a text axis treats each label as a category. Choose based on what the chart is meant to communicate, not simply on which option makes the labels fit.

Missing measurements need thought. A blank cell is not the same as zero: zero means a measured value of none, while a blank may mean no measurement was recorded. Select the chart, open Chart Design > Select Data, then use Hidden and Empty Cells in the Select Data Source dialog to choose how empty cells appear. Depending on the chart and settings, Excel can show a gap, connect points across the blank, or treat blanks as zero. Pick the treatment that accurately reflects the data; connecting across a gap can imply a continuous trend where no observation exists.

Common two-line chart problems

Only one line appears: Open Chart Design > Select Data and confirm that both series are listed and their value ranges contain numeric data. A series containing text instead of numbers may not plot as expected.
The months appear as lines or the legend looks wrong: Excel may have interpreted the rows and columns in the opposite direction. Try Chart Design > Switch Row/Column, then confirm the category labels and series names.
The line is broken: Check for blank cells, text values, or cells that contain errors. Decide whether a gap is appropriate before changing how Excel displays empty cells.
The chart includes unwanted totals or notes: Correct the selected data range in Select Data. It is usually better to exclude summary rows and explanatory notes than to format around them.
One line looks flat: The two series may have very different value ranges. First verify that the values and units are correct. A secondary vertical axis can make both trends visible, but it also changes the comparison: the apparent slopes and heights no longer share one scale.

Use a secondary axis cautiously. It can help when two valid series use very different units, such as temperature and rainfall, but it can also make unrelated magnitudes seem directly comparable. If you use one, label both axes clearly and explain the units. For two series measured in the same unit, a shared axis is normally easier to interpret.

Line chart or another chart type?

Choose a line chart when the sequence is meaningful and you want to emphasize change across it. A common example is comparing weekly website visits for two campaigns. A clustered column chart can be easier when readers need to compare the two values within each individual category, such as this year’s and last year’s results for a handful of departments.

Choose an XY scatter chart when the horizontal values are numeric measurements and their spacing matters—for example, comparing two responses measured at irregular time intervals. Scatter charts use numeric x-values, whereas a standard line chart generally places categories at evenly spaced positions. For only two observations, a line can technically be drawn, but a small table or a different visual may communicate the comparison more clearly.

Frequently Asked Questions

How do I add a second line to an existing Excel chart?
Select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, add a series and specify its name and value range, then confirm that the horizontal category labels match the existing chart. If the new data sits beside the current data, you can also expand the chart’s selected source range to include the extra column.

Can I make a two-line chart without a legend?
Yes. Select the legend and press Delete, or use Chart Design > Add Chart Element to change the legend setting. Remove it only if the lines are identifiable from direct labels, annotations, or context; otherwise readers may not know which line represents which series.

Why does Excel show one line instead of two?
The selected range may include only one value column, or Excel may have interpreted the table’s orientation differently. Check the series list in Chart Design > Select Data, and try Switch Row/Column if the series are organized in rows rather than columns. Also make sure the second series contains numeric values.

Can the two lines have different scales?
They can use separate vertical axes if you assign one series to a secondary axis through its formatting options. This is useful for different units, but it can mislead when both series represent the same kind of measurement. Prefer one shared scale when the goal is a direct comparison.

How do I show dots on both lines?
Choose Line with Markers when inserting the chart, or select a line and use its formatting options to enable markers. Markers make individual observations easier to locate, particularly in a chart with relatively few categories, but they can clutter a chart with many closely spaced data points.

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.