Excel Scatter Plots: Create, Format, and Interpret Them

How-to basics · Updated November 21, 2026

An Excel scatter plot shows the relationship between two sets of numerical values: one variable on the horizontal X-axis and another on the vertical Y-axis. In Microsoft Excel for Microsoft 365 on Windows, select the two data columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter to create one.

What an Excel scatter plot shows

Each marker in a scatter plot represents one paired observation. Its position is determined by an X value and a corresponding Y value. For example, a chart of weekly advertising spend and weekly sales might place spend on the horizontal axis and sales on the vertical axis. A cluster of points that generally rises from left to right suggests that higher spend and higher sales tend to occur together in the data.

Unlike a chart that emphasizes changes across named categories, a scatter plot treats both axes as numerical scales. This makes it useful for seeing the shape, strength, and direction of a possible relationship. It can also reveal outliers, clusters, gaps, and patterns that are hard to spot in a table.

  • Positive association: points tend to rise as they move from left to right.
  • Negative association: points tend to fall as they move from left to right.
  • Little apparent association: points do not form a clear upward or downward pattern.
  • Nonlinear pattern: points follow a curve or another shape rather than a straight trend.

A visible association does not establish that one variable caused the other to change. Other factors may affect both variables, and a small or unusual data set can make a pattern appear stronger than it is.

Prepare the data before charting

Arrange each observation as a pair on the same row. Put the X values in one column and the matching Y values in the next, with an optional heading above each column. For instance, column A could contain hours of practice and column B could contain scores. Row 2 must then hold the practice time and score for the same person, row 3 another matched pair, and so on.

Check the data before selecting it. Both columns should contain values Excel recognizes as numbers, not numbers stored as text. Remove or investigate accidental spaces, inconsistent units, duplicate records, and rows where one value belongs to a different observation. If the X and Y lists are sorted differently or one column has an extra row, the chart may show misleading pairs.

  • Use consistent units, such as minutes throughout rather than a mixture of minutes and hours.
  • Keep headings in the first row and avoid blank rows inside the data range.
  • Make sure each X value has the correct Y value on the same row.
  • Retain genuine unusual observations unless there is a documented reason to exclude them; an outlier may be important information.

Sorting the paired rows is not required for a scatter plot. If you do sort by X, sort the entire data range together so the relationship between each pair stays intact.

Create a scatter plot in Excel

For a basic chart in Excel for Microsoft 365 on Windows, select the two columns, including their headings if present. On the ribbon, select Insert > Insert Scatter (X, Y) or Bubble Chart, then choose the first Scatter option, usually shown as markers without connecting lines. Excel uses the first selected numerical column for X and the second for Y in the usual two-column layout.

  1. Click a cell in the data range or select the complete range.
  2. Open the Insert tab and select Insert Scatter (X, Y) or Bubble Chart in the Charts group.
  3. Choose Scatter with only Markers for a typical relationship chart.
  4. Check that the horizontal and vertical axes show the intended variables.

If the chart assigns a series incorrectly, select the chart and open Chart Design > Select Data. In the Select Data Source dialog, select the series and choose Edit to set its Series X values and Series Y values to the appropriate cell ranges. You can also add another series there. A series name can refer to a heading cell, which makes the chart legend easier to understand.

Excel for Mac also offers scatter charts from the Insert tab, although ribbon layout and labels can vary slightly by release. In Excel for the web, chart options and editing controls can differ from the desktop app; if a particular formatting control is unavailable, open the workbook in desktop Excel.

Choose markers, lines, or a bubble chart

Scatter-chart subtypes communicate different things, so choose based on the data rather than appearance alone. Scatter with only Markers is usually the clearest choice when each row is an independent observation. It avoids implying that one observation follows another in a meaningful sequence.

Scatter with Straight Lines and Markers, or Scatter with Smooth Lines and Markers, connects points in the order of the data rows. Use a connected version when the row order itself matters, such as measurements taken over time or a sequence along a path. For time-series data, a line chart may be more appropriate if the horizontal values are dates or categories and the emphasis is on change over time. Connecting unrelated observations can suggest a continuity that the data do not support.

A bubble chart adds a third numeric variable by varying the size of each marker. It can show three measures at once, but size comparisons are harder to judge precisely than positions on an axis. Use it only when the additional measure is meaningful and the bubbles do not overlap so much that they hide observations.

Add series and label the chart

A second series is useful when comparing groups, such as actual and forecast values or results from two locations. Each series needs its own X values and Y values. Use Chart Design > Select Data > Add, then specify the series name and the X and Y cell ranges. Distinguish series with clear marker colors or shapes, and include a legend when readers need to identify the groups.

Give the chart a descriptive title and label both axes with the variable name and unit. Select the chart, then use Chart Design > Add Chart Element > Axis Titles to add primary horizontal and primary vertical titles. For example, write Practice time (hours) rather than only Practice time if hours are the measurement. A useful chart title might state the comparison, such as Practice time and assessment score, without claiming that one measure caused the other.

For a small data set, labels on individual points can help identify observations. Select a series and use Chart Design > Add Chart Element > Data Labels. Labels can quickly clutter a chart with many points, so consider labeling only notable observations or using a separate table to identify them.

Format axes and add a trendline

To adjust an axis, right-click it and choose Format Axis. The Format Axis pane lets you set bounds, units, number formatting, and other scale options. A sensible scale helps readers compare points fairly. Setting the minimum to a nonzero value can magnify small differences, so make that choice visible and appropriate to the question rather than using it simply to make a pattern look dramatic.

A trendline summarizes a broad pattern; it does not connect every observation or prove a cause. Select the chart, then choose Chart Design > Add Chart Element > Trendline and select a type, such as Linear. For a more curved relationship, Excel offers other trendline types, but the chosen model should fit the data and the question. A polynomial trendline can follow fluctuations closely, especially at a higher order, while becoming less useful for explaining or predicting the general relationship.

To show a trendline equation or R-squared value, open More Trendline Options and select the corresponding display option. R-squared describes how well a fitted trendline accounts for variation in the charted data under that model; it is not a measure of causation and should not be treated as proof that the model is appropriate. A high value can also be driven by a small sample, an outlier, or a restricted range of observations.

Interpret patterns and avoid common mistakes

Look at the full cloud of points, not only the trendline. Ask whether the relationship is roughly linear, whether subgroups form separate clusters, whether the spread changes across the X range, and whether one observation has unusual influence. A curved pattern can be missed if you look only for a straight-line relationship. A pair of distinct clusters can create an overall trend that does not describe either group well.

Common chart problems often come from how the data are arranged or interpreted:

  • Wrong axes: edit the series in Select Data and verify the X and Y ranges.
  • Values appear at evenly spaced positions: check whether Excel inserted a line chart instead of a scatter chart; a scatter chart uses numeric X-axis spacing.
  • Numbers behave like text: convert the entries to numeric values and recreate or refresh the chart as needed.
  • Points overlap: reduce marker size, use transparency or different marker styles for groups, or inspect the underlying table. Overlap can conceal how many observations share a location.
  • An axis starts at an unexpected value: open Format Axis and review its bounds and units.
  • The trendline looks convincing but the conclusion feels uncertain: check sample size, data quality, outliers, and possible outside factors before drawing a conclusion.

Logarithmic axes can help display values spanning a very wide range, but a logarithmic scale changes how distances are interpreted and cannot display zero or negative values on that axis. Explain the scale clearly when readers may not expect it.

Scatter plots versus other Excel charts

A scatter plot is the natural choice when both variables are numeric and the spacing between X values matters. For example, values at 1, 2, and 10 should have distances that reflect their numerical gaps. A line chart generally spaces its horizontal categories evenly, even when the labels look numeric. That difference can change the visual message.

Use a column or bar chart to compare values across named categories such as departments or products. Use a line chart to emphasize a sequence, commonly measurements over time. Use a histogram to examine the distribution of one numeric variable rather than the relationship between two variables. These charts answer different questions; changing chart type does not fix incorrect or mismatched source data.

Frequently Asked Questions

How do I make a scatter plot in Excel?

Put paired X and Y numbers in adjacent columns, select the range, and choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Check the axis assignments, then add a chart title and axis titles that identify the variables and units.

How do I add a line of best fit in Excel?

Select the chart and choose Chart Design > Add Chart Element > Trendline > Linear. To display the fitted equation or R-squared value, open More Trendline Options and select the relevant display option. Treat the line as a summary of association, not proof of cause.

Why is Excel using the wrong X-axis values?

Select the chart and open Chart Design > Select Data. Edit the series and check that Series X values point to the intended numeric column and Series Y values point to the matching measurements. Confirm that the two ranges cover the same rows.

Can an Excel scatter plot have multiple data series?

Yes. Use Chart Design > Select Data > Add, then provide the name and separate X and Y ranges for each series. Use distinguishable marker styles and a legend so readers can tell the groups apart.

What is the difference between a scatter plot and a line chart?

A scatter plot positions points using numeric X values and preserves the spacing between those values. A line chart generally treats its horizontal entries as evenly spaced categories and connects them. Choose a scatter plot when the X values are measurements whose numerical spacing matters.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.