Excel Line Chart with Multiple Lines and a Secondary Axis

To make an Excel line chart with multiple lines, arrange each series in its own column, select the data, then choose Insert > Insert Line or Area Chart > 2-D Line. If the series use very different scales, select the outlying series and assign it to a secondary axis through Format Data Series > Series Options > Secondary Axis.

Arrange the data for a clear chart

Excel uses the selected table’s headers to name series and its first column or row to supply category labels. A layout with one time period per row and one measurement per column is usually easiest to read and update. For example, a monthly report could have Month, Website visits, Orders, and Returns as headers, followed by one row per month. Each measure becomes a separate line, and Month supplies the horizontal labels.

Keep the table rectangular: use one header row, one label column, and no completely blank rows or columns within the data. Make sure values intended as numbers are stored as numbers, not as text. Text entries such as “n/a” in a measurement column may be treated as zero or omitted in ways that affect the display; use a deliberate blank or an appropriate missing-value approach instead.

Put the time periods or categories in the first column, in the order you want them plotted.
Give each measurement column a short, distinctive heading.
Use consistent units within a series, such as dollars throughout or percentages throughout.
Include only the data you want charted, rather than totals or notes that could become unintended series.

If your data is arranged with series in rows instead, Excel may interpret the rows as series and the columns as categories. That can be appropriate, but verify the chart’s legend and horizontal labels after insertion.

Create the line chart in Excel

In Excel for Microsoft 365 on Windows, select the data range, including headers, and choose Insert > Insert Line or Area Chart. Select a 2-D Line option. The basic Line chart displays values as points connected by straight segments; Line with Markers also makes each observed value visible. Avoid 3-D line charts for ordinary reporting because perspective can make comparisons harder.

Excel normally recognizes the top row as series names and the first column as category labels. Check that the legend contains the measures you expect and the horizontal axis shows the intended periods. If Excel has interpreted rows and columns the wrong way, select the chart and use Chart Design > Switch Row/Column. This changes which direction Excel reads as a series; it does not rearrange or alter the source cells.

To add another series later, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, use Add to specify the series name and its values, then check that the category-axis labels cover the matching rows. If the source is an Excel table, adding data directly below it can expand the table and, depending on the chart’s source, update the chart automatically. Verify the result rather than assuming every chart range expands.

Understand what each line and axis represents

A line chart has one horizontal category axis and a vertical value axis. Each series is a sequence of values plotted against the same categories. In a monthly example, each point in Website visits corresponds to the same month as the point in Orders. This makes the chart useful for comparing direction, timing, peaks, and dips across several measures.

By default, all series share the same vertical scale. That is usually the fairest comparison when the series use the same units and have reasonably comparable magnitudes. If visits range from 10,000 to 20,000 while orders range from 200 to 500, a shared axis can make the orders line look nearly flat. The chart is not necessarily wrong; the gap in scale is simply dominating the picture.

Before adding an axis, ask what comparison the reader needs. A shared scale makes absolute size comparable. Separate scales can make changes in direction easier to see, but the apparent heights of the lines can no longer be compared as if they shared one measurement scale. State the units clearly and explain the axis assignment in the chart or its caption.

Add a secondary vertical axis

A secondary axis gives one or more series a separate vertical scale, typically on the right side of the chart. To assign a series to it, select that line in the chart, right-click, choose Format Data Series, and in the Format Data Series pane select Series Options > Secondary Axis. In some Excel layouts, the pane’s controls are shown as icons; hover over them or look for the Series Options label. The selected series should now use the right-hand vertical scale.

You can also use a combo chart when you want to control chart type and axis assignment together. Select the chart, choose Chart Design > Change Chart Type, and select Combo. Choose a chart type for each series and tick Secondary Axis for the series that needs its own scale, then confirm. A combo chart can still use lines for both series; the combo option is useful for setting their axis assignments in one dialog, or for pairing a line with a column series.

For example, a monthly chart might show revenue from $40,000 to $90,000 and customer satisfaction from 70% to 95%. Putting both on one scale is meaningless because the units differ. A secondary axis lets each series use a scale suited to its values. Add axis titles that identify dollars on the left and percent on the right, and retain a legend or direct labels so readers can tell which line belongs to which measure.

Use a secondary axis selectively. If the two vertical scales have different minimums or ranges, a small movement in one series can look as dramatic as a large movement in the other. Two lines crossing on a dual-axis chart do not mean their values are equal; the lines are positioned according to different scales. If the relationship between the actual values matters, use a common unit, a carefully explained indexed measure, or separate charts instead.

Set axis labels, bounds, and date spacing

To label the axes, select the chart and choose Chart Design > Add Chart Element > Axis Titles. Choose the relevant horizontal, primary vertical, or secondary vertical title. Use titles that include units, such as Orders per month or Revenue (USD), rather than repeating a vague label such as Value. The legend identifies series; axis titles explain what the scales measure.

To adjust a scale, select its axis, right-click, and choose Format Axis. In the Format Axis pane, use Axis Options to set bounds and major units where available. For example, a vertical axis that starts at 0 often helps readers compare magnitudes honestly. A nonzero minimum can be appropriate for a focused view of small variations, but it visually magnifies those changes; disclose the choice and avoid using it to imply a larger effect than the data supports. For a secondary-axis chart, check both scales independently.

Line charts treat the horizontal positions as categories, so equally spaced categories appear equally spaced. A line chart can be appropriate for daily or monthly observations when you want a sequence of periods in order. If dates are irregular and the actual elapsed time between observations matters—for instance, readings taken one day apart followed by a gap of three weeks—a line chart’s equal category spacing may mislead. Consider an XY (Scatter) chart, which uses numeric horizontal values and can represent unequal spacing. It is also a better choice when the horizontal values are measurements rather than labels.

Make several lines easy to compare

A chart with many series can become difficult to interpret even when the data is correct. Use descriptive series names, a clear chart title, and restrained formatting. Keep colors distinct, but do not rely on color alone when readers may print in grayscale or have color-vision differences. Markers, line styles, or direct labels can provide another way to identify a series. Avoid giving every line a heavy marker if the chart contains many observations; the points may overlap.

Use Chart Design > Add Chart Element to add a legend, gridlines, or titles where needed. A legend works well when lines remain visually distinct and the series names are concise. If the chart has only a few lines, data labels may clarify individual values, but labeling every point across many months can clutter the view. An alternative is to label the final point of each line manually or add a small table alongside the chart.

When displaying trends, consider whether smoothing is appropriate. A smoothed line changes the visual path between recorded values and can suggest intermediate behavior that was not measured. For exact observations, straight segments with or without markers are more transparent. If you do use a smoothed line, make sure the chart’s purpose supports that presentation.

Fix common multiple-line chart problems

The chart shows one line instead of several: Check the selected range and headers. Then try Chart Design > Switch Row/Column or use Chart Design > Select Data to add or correct the missing series.
The legend shows generic names: In Select Data, edit the series name to point to the correct header cell, or enter a clear name. A missing or blank header can leave Excel with an unhelpful default.
The horizontal axis shows 1, 2, 3 instead of dates or months: Use Select Data to set the correct category-axis label range. Check that labels are in the data range and not accidentally excluded.
One line looks flat: Confirm that the series has the same units as the others. If its scale differs substantially, consider a secondary axis, an indexed comparison, or separate charts—not an unexplained scale change.
Gaps or unexpected drops appear: Inspect the source cells for blanks, text, errors, or zeros. A blank is not the same as a zero: zero is a measured value at the baseline. Excel’s handling of empty cells can be reviewed through Chart Design > Select Data > Hidden and Empty Cells.
The chart changes when new rows are added: Check whether the chart source includes the new rows. Converting the source data to a table with Insert > Table can make a growing dataset easier to manage, but confirm that the chart includes the expanded data.

When to choose another chart type

A multiple-line chart is strongest when the horizontal order matters and the purpose is to compare trends across categories or time. It is not automatically the best choice for every set of numbers. Use an XY (Scatter) chart when the horizontal variable is numeric and spacing between values carries meaning. Use separate small charts when a dual axis would confuse readers or when many lines overlap too much.

If the main task is comparing values at a single point in time, a bar or column chart can make differences easier to judge. If you need to show the composition of a total over time, a stacked area chart may fit, though it is harder to compare the middle series precisely. For a report with measures in incompatible units, two clearly titled charts may communicate more honestly than one crowded dual-axis chart.

Frequently Asked Questions

How do I add a second line to an Excel chart?
Select the chart and choose Chart Design > Select Data > Add. Set the series name and the cell range containing its values, then check that its category labels align with the existing series. If the new measure is already in the selected data range, Switch Row/Column may correct the chart without adding it manually.

Can a line chart have two vertical axes?
Yes. Select the series that needs its own scale, open Format Data Series, and choose Series Options > Secondary Axis. The chart then displays a second vertical scale, normally at the right. Add axis titles and identify which line uses which axis so the difference is clear.

Should I use a secondary axis for different units?
It can make unlike units visible together, but it also makes the lines’ vertical positions incomparable. Use it only when the relationship or timing between trends is useful, label both scales explicitly, and consider separate charts if readers could mistake the lines as sharing a scale.

How do I change which data appears as lines?
Select the chart and choose Chart Design > Switch Row/Column. If that does not produce the desired result, use Chart Design > Select Data to edit the series and category label ranges directly.

Can I make a line chart with dates on the horizontal axis?
Yes. Include the date cells as category labels and verify that Excel uses them rather than numeric position labels. A line chart spaces categories evenly; for irregular dates where gaps must reflect actual elapsed time, choose an XY (Scatter) chart instead.

These steps apply to Excel for Microsoft 365 on Windows. Excel for Mac has the same chart concepts, though ribbon placement and pane appearance can vary slightly; select the chart and look for the Chart Design and Format tabs. Excel for the web supports common chart creation and formatting, but some detailed chart controls may differ from the desktop app.

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.