Excel Line Chart Overlapping Lines? Causes and Fixes

If lines overlap in an Excel line chart, first check whether the plotted values are identical or simply too close to distinguish; then inspect the vertical-axis scale and series order. In Excel for Microsoft 365 on Windows, use Chart Design > Select Data to verify the source and order, and format the series with markers or distinct line styles if the data is correct.

Why lines overlap in an Excel chart

Several different situations can look like the same problem. Two series may contain exactly the same values, one series may sit directly on top of another, or values may be so similar that their lines appear merged at the chart’s size. A steep or poorly chosen vertical-axis scale can also make meaningful differences hard to see. Finally, the chart may be plotting data differently from what you expect because a range, date column, or series was selected incorrectly.

For example, suppose a chart compares actual sales and a forecast for four months. If both series are 100, 120, 130, and 150, their lines coincide at every point. If actual sales are 100, 120, 129, and 150, the series differ only slightly at one point and may look like one line unless the chart is enlarged or uses markers. No formatting can make identical values occupy different positions without changing how the chart represents the data.

It is also useful to distinguish overlapping lines from crossing lines. Lines cross when one series changes from being higher than another to being lower. That can be a real and informative feature of the data, not a chart error. Overlap means the plotted positions coincide for some or all of the categories.

Check the source data and series selection

Before changing the chart’s appearance, confirm what Excel is plotting. Select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, review the chart data range and the list under Legend Entries (Series). Check that each intended series has the correct name and values, and that the horizontal category labels point to the expected dates, months, or labels.

Compare the source values. Look down the columns or rows for repeated values, copied formulas, or two series that reference the same range.
Check the series ranges. In Select Data, select a series and choose Edit to inspect its series name and values. Make sure it does not include a heading or an unintended column.
Confirm the chart orientation. If months and series have been interpreted in reverse, choose Chart Design > Switch Row/Column and see whether that matches the intended comparison.
Check the displayed legend. A missing or repeated legend name can make it difficult to tell which line belongs to which data column.

If the chart comes from an Excel table, adding rows to the table usually expands the chart’s source automatically. A chart made from a manually selected range may not include later rows, so verify the range when new categories are missing. These checks can reveal a data-selection issue that formatting alone would not fix.

Adjust the vertical-axis scale carefully

A wide vertical-axis range can compress differences between lines. For instance, values around 98 and 102 will be close together on an axis running from 0 to 1,000. To inspect the spacing more clearly, right-click the vertical axis, choose Format Axis, and use Axis Options in the formatting pane to set suitable Bounds and Units. Excel may set the bounds to Auto; entering a smaller minimum and maximum can make small variations easier to see.

Choose bounds that fit the purpose of the chart, and label the scale clearly. A truncated axis can make modest differences look dramatic, particularly in reports where readers may assume the axis starts at zero. Line charts do not always need a zero baseline, but the choice should be deliberate and visible rather than a trick to separate the lines. If the chart compares quantities where the size of the difference matters, preserve enough axis context for readers to judge it.

Changing the axis scale will not separate series with identical values. It only changes how the existing values are displayed. It can also make a chart harder to interpret if readers have to infer an unusual range, so consider adding an axis title or a note when a nonzero minimum is important to the message.

Use markers, line styles, and color to distinguish series

When lines are close together, give readers more than color alone to identify them. Select a line in the chart, right-click, and choose Format Data Series. In the formatting pane, use Fill & Line to adjust the line color, width, dash type, or transparency where available, and use Marker options to add or change point markers. The exact controls shown depend on the selected chart type and series.

Add markers: Use different shapes, such as circles and squares, so nearby series remain distinguishable at their data points.
Vary line patterns: Use a solid line for one series and a dashed or dotted line for another. This helps in grayscale printouts and for readers who do not distinguish the colors easily.
Use contrasting colors: Pick colors with clearly different brightness as well as hue. Avoid relying on two similar shades.
Reduce clutter selectively: If a dense chart has many categories, markers on every point may crowd the display. Consider markers on only a few key series, or use a thinner line for less important context.

You can select Chart Design > Change Chart Type and choose a line style that includes markers, or format individual series to use different marker settings. Formatting a series affects its appearance, not its underlying values. Keep the design consistent enough that readers can follow a series from the legend to the plotted line.

Change the series drawing order

When two lines coincide, the series drawn later can cover the one drawn earlier. Changing the order can bring a hidden line to the front, which is especially useful if the series have different markers or line styles. Choose Chart Design > Select Data, select a series under Legend Entries (Series), and use the move-up or move-down controls in the dialog to change its position. The order in the legend may change as well, so check that it remains easy to follow.

This is a visibility fix, not a data fix. If two series have exactly the same values and identical formatting, moving one above the other will only change which line is visible; it will not show that two series exist. Assign the series different markers or line patterns, and use clear legend names, if the fact that both series are present matters to the reader.

Check dates, missing values, and chart type

Line charts are designed to show changes across categories such as months or dates. In a standard line chart, the horizontal axis is a category axis: categories are generally spaced evenly, even if the time between dates is not equal. If your dates are irregular and the actual distance between them matters, an XY (Scatter) chart with lines may be more appropriate. It uses numeric horizontal positions, so uneven intervals can be represented proportionally. Choose Chart Design > Change Chart Type to compare available chart types.

Missing entries can also change the apparent shape of a line. To review how Excel treats empty cells, select the chart and choose Chart Design > Select Data, then choose Hidden and Empty Cells in the dialog. Depending on the available options, empty cells can appear as gaps, be plotted as zero, or be connected across. A zero can pull a line sharply down, while connecting across a gap can suggest continuous data where none was recorded. Select the treatment that accurately describes the data rather than the one that merely looks smooth.

If the chart’s categories or values are being interpreted incorrectly, inspect the source ranges before switching chart types. A different chart type may change the visual encoding, but it cannot correct an incorrect series range or missing data.

Use a secondary axis only for different scales

A secondary vertical axis can help when series use different units or have genuinely different magnitudes, such as revenue and a percentage rate. In Excel, choose Chart Design > Change Chart Type and use the Combo options, if available for the selected chart, to assign a series to a secondary axis. Then label both axes so readers know which scale belongs to each series.

A secondary axis is usually not a good way to separate two similar series that share the same unit. Changing scales can make the lines appear to meet, diverge, or move together in ways that reflect the chosen axes rather than a meaningful relationship. If both series are measurements of the same kind, keep them on one scale and use markers, line patterns, or separate charts to clarify the comparison.

When separate charts are clearer

Formatting has limits. A single chart can become difficult to read when it contains many overlapping series, frequent crossings, or dense daily data. If the audience needs to compare trends but not inspect every value at once, split the series into small multiples: separate charts with the same horizontal range and, where appropriate, the same vertical scale. Readers can then compare patterns without lines concealing one another.

Another option is to show the overall trend in the main chart and provide a focused detail view for the period where the lines are closest. A data table below the chart can help readers check exact values, although it does not replace a clear visual. Avoid using a stacked line chart simply to force lines apart: stacking adds series cumulatively, changing what the heights represent. It is only suitable when that cumulative interpretation is intended.

Frequently Asked Questions

Why does Excel show only one line when I have two series?

The series may contain identical values, or one may be drawn directly over the other. Check both ranges in Chart Design > Select Data, then give the series distinct markers or line styles to reveal coincident data.

How do I bring a hidden line to the front?

Choose Chart Design > Select Data, select the series, and use the move-up or move-down controls to change its order. Then format the series differently if the lines have the same values.

Can I fix overlapping lines by changing the axis minimum?

Changing the vertical-axis bounds can make small differences easier to see, but it cannot separate identical values. Use a clearly labeled scale and avoid bounds that exaggerate the size of a difference.

Should I use a secondary axis to separate two lines?

Usually not when both series use the same unit. A secondary axis is intended for a series on a different scale or unit, and it can distort visual comparisons if used only to create space.

Why do my dates look evenly spaced when the gaps are not equal?

A standard line chart treats its horizontal labels as categories, which are usually spaced evenly. For irregular numeric or date intervals where spacing matters, consider an XY (Scatter) chart with lines.

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.