Excel Scatter Plot: Connect Dots, Choose Lines, Fix Issues

Yes. To connect points in an Excel scatter plot, choose a scatter chart type with lines: select Insert > Insert Scatter (X, Y) or Bubble Chart, then pick Scatter with Straight Lines and Markers or Scatter with Smooth Lines and Markers. For an existing chart, use Chart Design > Change Chart Type and select the same type.

What connecting dots means in a scatter plot

An XY scatter chart plots each observation using two numeric values: one on the horizontal (X) axis and one on the vertical (Y) axis. A marker represents each pair. A scatter chart with lines adds a segment between consecutive observations in the series, so the chart shows both the individual measurements and their sequence.

That line is a visual link between recorded points. It does not automatically calculate a trend, predict values between measurements, or establish that one variable causes another. A straight segment simply shows the path between adjacent points; a smooth line draws a curved visual path. Neither should be mistaken for additional measured data.

Connecting markers is useful when the sequence has meaning, such as measurements over time, a machine’s operating path, or values recorded as an experiment progresses. If the goal is only to show whether two variables are associated, markers without connecting lines are often clearer.

Create a scatter plot with connected points

For a simple chart in Excel for Microsoft 365 on Windows, arrange the X values and Y values in neighboring columns. For example, put elapsed time in column A and temperature in column B, with headers in row 1 and observations in rows 2 through 7. Then:

Select the two columns of data, including their headers.
Choose Insert > Insert Scatter (X, Y) or Bubble Chart.
Under the Scatter options, select Scatter with Straight Lines and Markers for direct connections, or Scatter with Smooth Lines and Markers for a curved appearance.
Check that elapsed time appears on the horizontal axis and temperature on the vertical axis. Add a chart title and axis titles if they will help readers interpret the measurements.

The chart gallery also offers line-only versions. Use one of those if the connecting path matters but the individual markers would make the chart crowded. The exact gallery arrangement can vary with window size, but the chart types are available from the scatter-chart menu.

Excel usually identifies the first selected column as X values and the next as Y values when the data are laid out in this common two-column format. If the chart assigns them incorrectly, edit the series rather than rearranging values by eye. Keeping each observation’s X and Y values on the same row is important.

Change an existing scatter chart to connect its points

If you already have a scatter chart with markers, select the chart and choose Chart Design > Change Chart Type. In the dialog, choose X Y (Scatter), then choose a scatter option that includes straight or smooth lines. Select OK to apply it. If the chart contains several series, check the type assigned to each one; a chart can display different types for different series in some chart configurations.

You can also check the series ranges if the chart does not connect the points you expected. Select the chart, choose Chart Design > Select Data, select a series, and choose Edit. Confirm that the X values and Y values refer to the intended cells and cover the same number of observations. A series with mismatched or incomplete ranges can plot incorrectly.

In Excel for Mac, chart commands are organized somewhat differently depending on the app version and ribbon layout, but the chart-type names are the same. Look for the scatter-chart choices on the Insert tab, or select the chart and use its chart-design controls to change its type.

Arrange and sort data in the right order

Excel connects points in the order they appear in the series, not necessarily in ascending X order. This is a key difference between a scatter chart and a chart that merely places categories in a fixed sequence. If your rows list X values as 1, 3, 2, a connected scatter chart follows 1, then 3, then 2. The line can double back, even though the horizontal axis itself is numeric.

When the intended story is how Y changes as X increases, sort the observations by X before charting. Sort the complete data table, not just the X column: each row’s related values must stay together. Sorting only the X values would pair measurements with the wrong observations and produce a misleading chart.

For example, suppose a table contains time and temperature measurements entered in the order 0, 10, 5, 15 minutes. A connected plot follows that recording order and travels from 10 back to 5 before reaching 15. If the purpose is to show the temperature curve over time, sorting the full rows by time gives the sequence 0, 5, 10, 15. If the sequence instead represents the order of a process or route, preserve that order rather than sorting.

For more than one data series, each series has its own X and Y ranges. Use Chart Design > Select Data to add or edit series and check their ranges. This is useful when comparing several experiments that share a horizontal scale but have separate measurements.

Choose straight lines, smooth lines, or markers only

Straight lines with markers: Good for measurements where the direct segment between recorded points is meaningful, such as a path or a sequence of readings. Markers make the actual observations visible.
Smooth lines with markers: Useful when a curved visual presentation is appropriate and the data are dense enough to support it. Smoothing changes the appearance between points; it does not add measurements or guarantee a physically accurate curve.
Straight or smooth lines without markers: Helpful when many observations overlap and the line is more important than showing every point. Consider keeping markers if readers need to identify exactly where observations were recorded.
Markers only: Usually best for an unordered collection of paired values, such as comparing height with weight across individuals. A connecting line can imply an order or path that the data do not have.

If the data represent time, a line often seems natural, but the right choice depends on what the horizontal values mean. A scatter chart treats X values as numbers and spaces points according to their numeric distance. A line chart typically treats horizontal entries as categories. With irregular time intervals, such as readings one hour apart followed by a gap of six hours, an XY scatter chart shows the spacing more faithfully.

Format the connected scatter plot for readability

Lines and markers can quickly make a chart difficult to read, especially when multiple series overlap. Select a series to format its marker and line appearance. Keep the line visible but not so heavy that it hides the markers, and use distinct colors or marker shapes when readers must compare several series. Avoid relying on color alone if the chart may be printed in grayscale or viewed by someone with color-vision differences.

Use axis titles to state units, such as Time (minutes) and Temperature (°C), rather than expecting readers to infer them. A descriptive chart title should explain what is measured or compared. If the X values cover a wide range, check that the axis scale does not compress important differences; if the values include zero, do not assume the axis must start at zero, but choose a range that makes the pattern interpretable without exaggerating it.

For a chart with many observations, try smaller markers or a line-only chart. If several series overlap, make sure each series is named clearly in the legend and consider splitting the chart if the comparisons are too dense. Formatting should help readers distinguish recorded points from the connecting path, not make one look like the other.

Common problems and how to fix them

The chart looks like it skips around: The rows may be out of the intended X order. Sort entire rows by X if the chart should progress from low to high X, or preserve the original sequence if it represents an actual process.
The wrong values appear on an axis: Open Chart Design > Select Data, edit the series, and check which cell range is assigned to X values and which to Y values. Confirm that both ranges contain the intended observations.
Only markers appear: The chart may still be a markers-only scatter type. Use Chart Design > Change Chart Type and select a scatter option that includes lines.
There is a break where cells are blank: Excel can display empty cells as gaps, zeros, or connected data points depending on the chart’s empty-cell setting. Select the chart, choose Chart Design > Select Data, then open Hidden and Empty Cells to review the available empty-cell choices. Connecting across a blank can imply continuity where no measurement was recorded, so use it only when appropriate.
The smooth curve looks misleading: Switch to straight lines or markers only. A smoothed path can visually suggest a shape between observations that the measurements do not establish.
One point is far away from the rest: Check the source value and units before changing the axis scale or removing the observation. An outlier may be a data-entry error, but it may also be a genuine result that should remain visible.

When the chart still seems wrong, inspect the source table for text values, blank cells, duplicate X values, or inconsistent units. Excel needs numeric X and Y values to position a scatter series as intended. A cell that looks numeric but is stored as text may not behave like a proper measurement, so check the cell contents and formatting before adjusting the chart design.

When a line chart or trendline is a better choice

A line chart is often a better fit when the horizontal axis represents evenly spaced categories, such as months, product names, or stages, and the exact numeric distance between labels is not important. A scatter chart is better when both axes contain numeric measurements and the spacing between X values matters. These chart types may look similar, but they answer different questions about the horizontal scale.

A trendline is different from connecting dots. A trendline summarizes a pattern, for example with a linear fit, while a connecting line links the observations in sequence. If you want to show an overall relationship rather than the route through individual records, select the data series and use Chart Design > Add Chart Element > Trendline, then choose an appropriate option. A trendline is a model of the data, not a line that passes through every point.

For a cyclical or irregular pattern, connecting points may be more informative than a single trendline. For a large unstructured dataset, markers alone can reveal clusters without inventing an order. Choose the representation that matches how the data were collected and what readers need to learn from them.

Frequently Asked Questions

How do I connect dots in an Excel scatter plot?
Select the chart and choose Chart Design > Change Chart Type. Under X Y (Scatter), choose Scatter with Straight Lines and Markers or a smooth-line option. When creating a chart, select that type from the Insert scatter-chart gallery.

Does Excel connect scatter-plot points in X order?
No. Excel connects points in the order of the observations in the series. Sort the entire data table by X if increasing X order is what you intend; do not sort one column separately from its paired values.

Can I connect points without showing markers?
Yes. Choose a scatter chart type with straight or smooth lines but without markers. This can reduce clutter when a series contains many points, though it makes the exact locations of individual observations less obvious.

Should I use a scatter plot or a line chart for data over time?
Use a scatter chart when the time values are numeric and unevenly spaced, because it preserves the actual distance between times. A line chart can suit evenly spaced time categories when each interval should occupy the same horizontal space.

Why does my scatter plot connect points in the wrong direction?
The series follows worksheet row order, which may not match the order you expect along the X axis. Sort complete rows by X for a left-to-right progression, or edit the series ranges if Excel is using the wrong cells.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.