Microsoft Excel Scatter Plot: How to Create and Read One

In Microsoft Excel for Microsoft 365 on Windows, put the X values in one column and their matching Y values in the next, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart and pick a scatter subtype. Excel plots each row as a point, letting you see how two numeric variables relate; you can then label the axes, format the chart, and add a trendline if it helps explain the pattern.

What a scatter plot shows

A scatter plot, also called an XY chart, represents paired observations as points on two value axes. The horizontal axis carries the X value and the vertical axis carries the corresponding Y value. For example, a small business might plot advertising spend on X and weekly sales on Y. Each point represents one week, so a cluster rising from left to right suggests that higher spending is associated with higher sales in the observed data.

The chart is useful for spotting relationships that a list of numbers can hide: a general upward or downward pattern, a curved relationship, groups of observations, gaps, and unusual points. It does not establish why a relationship exists. In the advertising example, seasonality or a change in pricing could affect sales too, so a rising pattern alone does not prove that advertising caused the increase.

Scatter charts are most informative when each X value has a meaningful numeric position. They are commonly used for measurements such as time against temperature, height against weight, distance against travel time, or product price against units sold. A chart can show a relationship clearly, but the choice of variables and the quality of the underlying data still matter.

Prepare the worksheet data

Arrange the observations in paired columns, with one row per observation. Put the X variable in the first column and the Y variable beside it, and use clear headings in the top row. For example, A1 could contain Advertising Spend, B1 Weekly Sales, and rows 2 through 13 could contain twelve matching weeks. The values on each row must belong together: Excel pairs A2 with B2, A3 with B3, and so on.

Use numeric values for both variables. Numbers stored as text may not plot as expected.
Keep the same units and definitions throughout a series. Do not mix dollars and thousands of dollars without converting one set.
Remove or investigate accidental blanks, duplicate records, and obvious data-entry errors before interpreting the shape.
Keep headings in the selected range. Excel can use them as a series name, though you can also name the series later.

Dates are valid numeric values in Excel, so a date can be used as an X value. If the chart displays dates as serial numbers or with an unhelpful scale, format the horizontal axis as dates. If X values are categories such as product names rather than quantities, a scatter plot may not be the best choice; a column or line chart may communicate the data more naturally.

Create a scatter plot in Excel

Click and drag to select the two columns of paired data, including the headings. If the columns are separated, select the first range and hold Ctrl while selecting the other range in Windows; for a chart with several series, it is often clearer to create the chart first and add each series through Select Data.
Choose Insert > Insert Scatter (X, Y) or Bubble Chart in the Charts group.
Select the subtype that fits the purpose, such as Scatter with only Markers. Excel inserts the chart on the worksheet.
Check that the horizontal axis uses the intended X values and the vertical axis uses the intended Y values. If the chart is wrong, use Chart Design > Select Data, select the series, and choose Edit to set its Series X values and Series Y values.
Use Chart Design > Add Chart Element to add a chart title and axis titles, and use the Format tab or the formatting pane to adjust the appearance.

In the Windows desktop app, the Insert Scatter command is in the Insert tab. In Excel for Mac, the chart options are also on the Insert tab, but the ribbon layout and labels can vary slightly by release. Excel for the web supports charts, although some detailed formatting and chart-editing options may differ from the desktop app.

Choose the right scatter subtype

Excel offers several XY chart styles. Scatter with only Markers is a good default when the observations are separate measurements. It displays points without implying that one observation should connect to the next. This is usually appropriate for comparing two variables across people, products, locations, or independent trials.

Scatter with Smooth Lines and Markers or Scatter with Straight Lines and Markers connects points in the series. Use connecting lines when the sequence has meaning, such as measurements taken in time order or along a continuous process. Be cautious: Excel connects points in the order of the worksheet rows, not automatically by increasing X value. If the order matters, sort the data by X before using a line subtype; otherwise, the line can zigzag and suggest a path that was never intended.

Scatter with Smooth Lines or Scatter with Straight Lines omits markers. This can make a dense series less cluttered, but it can also hide the individual observations. A bubble chart is a related option that adds a third numeric measure through bubble size; it is not simply another name for an ordinary scatter plot.

Format axes, titles, and points

A useful chart explains itself. Give it a specific title, such as Weekly Sales and Advertising Spend, rather than leaving the generic Chart Title. Add axis titles that include units, for example Advertising Spend (USD) and Sales (units). This helps prevent readers from confusing a value of 5 with $5,000 or five thousand units.

To add labels in Excel for Microsoft 365 on Windows, select the chart and choose Chart Design > Add Chart Element > Axis Titles, then select the horizontal or vertical axis title. You can click the title on the chart and type the wording. To format an axis, right-click it and choose Format Axis; the pane includes controls such as bounds, tick marks, number format, and scale options. Changing the minimum or maximum can focus attention on a range, but disclose or consider the effect: a truncated axis can make a modest difference look dramatic.

Use marker color and size to make points visible without overpowering the data. If the chart contains multiple series, give each a distinct marker or color and retain a clear legend. Avoid relying on color alone when the chart may be printed in grayscale or viewed by someone with color-vision differences. Gridlines can support reading values, but too many dark gridlines compete with the points.

Add a trendline and interpret the pattern

A trendline summarizes a pattern; it does not replace the points. To add one in Excel for Microsoft 365 on Windows, select the data series, choose Chart Design > Add Chart Element > Trendline, and select a type such as Linear. You can also right-click a series and choose Add Trendline. A linear trendline is appropriate when the relationship is reasonably straight across the plotted range. Excel also offers other trendline types, including logarithmic, polynomial, power, and exponential, but a more flexible curve can overfit a small or noisy data set.

When you format a trendline, Excel can display its equation and R-squared value on the chart. The equation describes the fitted line; R-squared indicates how closely the observations fit that model in the context of the chosen trendline. Neither number proves causation, confirms that the model is suitable, or guarantees accurate predictions outside the observed range. A high R-squared can coexist with biased data or a misleading model, while a low one may reflect substantial natural variation.

Look at the points as well as any summary statistic. A few extreme observations can pull a fitted line, a curved pattern can be poorly described by a straight line, and clusters may represent different groups. Check the source records before removing an outlier: it could be an error, or it could be a genuine and important observation.

Multiple series and unusual data

To compare groups, plot each group as a separate series and use the same X and Y scales where possible. For instance, a lab might compare two materials by plotting temperature against expansion, with one series for each material. Choose Chart Design > Select Data > Add to create a series, then provide its name, X values, and Y values. Keep the X and Y ranges the same length and align the paired rows. The legend should identify groups in plain language.

When a chart has unexpected gaps or missing points, inspect the source cells and the chart’s handling of empty cells. In the desktop app, select the chart and use Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed. A blank is not always equivalent to zero: replacing missing measurements with zero can create false points and distort the apparent relationship. Decide whether a value is missing, not applicable, or truly zero before changing it.

For a dense data set, overlapping markers may hide how many observations occupy the same area. Smaller or partly transparent markers, if available in the formatting options, can help. You can also filter the source data or separate meaningful groups into different series, but make the filtering clear so readers understand which observations are shown.

Common problems and how to fix them

The axes are reversed: Open Chart Design > Select Data, edit the series, and assign the intended X range to Series X values and the intended Y range to Series Y values.
The chart shows one point or an unexpected series: Check that the selected ranges include both numeric columns and that the series ranges cover all intended rows.
Points appear in odd places: Look for numbers stored as text, inconsistent units, misplaced decimal points, or an incorrect X/Y pairing.
The horizontal axis looks categorical: Confirm that the chart type is an XY scatter chart, not a line chart. Scatter charts position X values numerically; line charts commonly space categories evenly.
A connected chart zigzags: The rows may not be ordered by X. Sort complete rows together by the X column, or choose markers only if connecting observations is not meaningful.
The trendline seems implausible: Check for outliers, a nonlinear pattern, separate clusters, and an unsuitable trendline type before relying on its equation.

Scatter plot versus line chart

Both chart types can show values across time, but they treat the horizontal axis differently. A scatter chart uses a numeric value axis for X, so the horizontal distance between points reflects the difference between their X values. A line chart generally treats the horizontal entries as categories and spaces them evenly. If measurements were taken on days 1, 2, and 20, a scatter chart shows the long gap between days 2 and 20; a line chart can give the three dates equal spacing.

Choose a scatter chart when the exact numeric X positions matter or when you want to study the relationship between two measured variables. Choose a line chart when the main story is a sequence of categories or time periods with regular spacing, and the exact interval between category labels is not being represented as a numeric distance. The chart type should match the question, not just the shape that looks familiar.

Frequently Asked Questions

How do I make a scatter plot in Excel?

Place paired numeric X and Y values in adjacent columns, select the data, then choose Insert > Insert Scatter (X, Y) or Bubble Chart and select a scatter style. Add axis titles so readers know what each scale measures.

How do I change the X and Y values?

Select the chart and choose Chart Design > Select Data. Select the series, choose Edit, and specify the ranges for Series X values and Series Y values. Make sure the two ranges contain matching observations in the same row order.

Can a scatter plot have more than one data series?

Yes. Add each group as a separate series through Chart Design > Select Data > Add, then set that series’ name and X and Y ranges. Use a legend and consistent scales to make comparisons understandable.

Why does Excel connect my scatter plot points?

You may have chosen a scatter subtype with straight or smooth lines. Choose Scatter with only Markers if the observations should remain separate. If the connecting order matters, arrange the worksheet rows in the intended sequence first.

Should I use a trendline on every scatter plot?

No. Add a trendline only when a fitted summary helps answer the question and the chosen model is reasonable for the pattern. Keep the original points visible and do not treat a trendline or its R-squared value as proof of cause and effect.

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.