Scatter Plot in Excel: Create, Format, and Read It

To make a scatter plot in Excel for Microsoft 365 on Windows, put your X values in one column and your Y values in the next, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Excel plots each row as a point, letting you see how two numeric variables relate.

What a scatter plot shows

A scatter plot, also called an XY chart, displays paired measurements as points on two value axes. The horizontal axis represents the X variable and the vertical axis represents the Y variable. For example, if each row records a house’s floor area and sale price, floor area can be X and price can be Y. Each house appears as one point at its corresponding pair of values.

The overall arrangement can reveal patterns that are difficult to see in a table. Points rising from left to right suggest a positive association: larger X values tend to occur with larger Y values. A downward pattern suggests a negative association. A shapeless cloud may indicate a weak or absent relationship, while separated groups can suggest that the data contains distinct categories or populations.

A scatter plot can reveal association, clusters, and unusual points, but it does not prove that one variable causes another. Other factors may influence both variables, and an apparent pattern can depend on which observations are included. Treat the chart as a way to explore and communicate data, not as proof of a cause.

Prepare the data in two columns

Arrange each observation on its own row, with the X measurement in the first column and the matching Y measurement in the second. Use a clear header in the top cell of each column, such as Hours Studied and Test Score. Keep each X value on the same row as the Y value it belongs with; sorting only one column would break the pairs and produce misleading points.

Both columns should contain values Excel can interpret as numbers. Text such as 12 hours may not be recognized as a numeric value, and inconsistent entries can cause points to be omitted or plotted incorrectly. If your source data includes units, keep the measurements numeric and put the units in the column heading or axis title. Check that decimal separators and date formats match your regional settings.

Before making the chart, consider these checks:

Each row is one paired observation, and there are no accidental blank rows in the middle of the data.
The two columns have the same number of observations and their headers identify the variables.
Missing, duplicate, or unusually large values are intentional and have not resulted from a data-entry error.
If you have categories, such as product type, decide whether to use separate series or simply show all observations together.

Dates can serve as X values when Excel recognizes them as dates; Excel then positions them according to their underlying numeric date values. If the dates are stored as text, the chart may not space them as expected. Converting them to actual Excel dates can resolve that issue.

Create a basic scatter plot

On Windows, select the two columns, including their headers, and open the Insert tab. Choose Insert Scatter (X, Y) or Bubble Chart, then select Scatter for points without connecting lines. Excel creates a chart using the first selected numeric column for X and the second for Y. If you select nonadjacent columns, hold Ctrl while selecting the ranges; selecting adjacent columns is usually simpler and less error-prone.

Click a cell in the data, or select the complete two-column range.
Choose Insert > Insert Scatter (X, Y) or Bubble Chart.
Select the basic Scatter option, usually shown with markers and no lines.
Move or resize the chart, then replace the default chart title with one that explains what is being compared.

If Excel has interpreted the columns in the wrong direction, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, check the series and its X and Y ranges. Select the series and choose Edit to assign the correct ranges. A single XY series needs separate X values and Y values; unlike some other chart types, it is not simply a list of categories with one value per category.

Excel for Mac has a similar chart-insertion workflow through the Insert tab, though the ribbon layout and dialog appearance can vary by release. Excel for the web also supports basic chart creation, but chart formatting and editing options may differ from the Windows desktop application.

Choose markers, lines, and series

The basic scatter chart shows markers only, which is generally appropriate when each point is an independent observation. Excel also offers variants with straight lines or smooth lines, with or without markers. Connecting points can be useful when the X values have a meaningful order, such as measurements taken over time, but it can imply continuity or sequence that is not present in unrelated observations. A smooth line is a visual curve, not evidence that the data follows a smooth mathematical relationship.

To compare groups, create one series per group. For example, a study might show one series for morning measurements and another for evening measurements, each with its own X and Y ranges. Select Chart Design > Select Data, then use Add in the dialog to create a series and specify its name, X values, and Y values. Use different marker colors or shapes so the groups remain distinguishable. A legend is helpful when the chart has multiple series; for one series, it may take up space without adding much information.

Do not use a bubble chart unless a third numeric variable is intended to control bubble size. A standard scatter plot encodes two numeric variables by horizontal and vertical position. Bubble charts add size as a third visual encoding, and their bubbles can overlap, making precise comparisons harder.

Format axes and labels for clarity

A clear chart tells readers what each axis measures and what units the values use. Select the chart, then choose Chart Design > Add Chart Element > Axis Titles to add horizontal and vertical titles. Select each title and type a meaningful label, such as Temperature (°C) or Distance (km). You can add or edit a chart title through Chart Design > Add Chart Element > Chart Title. A descriptive title should explain the comparison rather than repeat a generic label such as Chart Title.

To adjust the scale, right-click an axis and choose Format Axis. The Format Axis pane lets you set bounds, units, number formats, and other options. The automatic scale is often a good starting point, but a deliberate scale can make the plotted range easier to read. Be cautious about forcing the vertical axis to start above zero: this can make small differences look much larger than they are. For scatter plots, the axis scale should suit the data and the comparison being made, not merely make the pattern look stronger.

Use markers large enough to see but not so large that dense data becomes a solid patch. If many observations overlap, reduce marker size or use transparency where the formatting controls offer it. Data labels are useful for a small number of points—for example, to identify specific products—but labeling every point in a large dataset can make the chart unreadable. Gridlines can help readers estimate values; retain only the ones that improve navigation.

Add a trendline and understand its limits

A trendline summarizes a pattern in a series. Select the chart, choose Chart Design > Add Chart Element > Trendline, and select an appropriate type, such as Linear. To see additional settings, choose More Trendline Options. Excel supports several trendline forms, including linear, logarithmic, polynomial, power, and exponential; the right choice depends on the data and the question, not on which line looks most persuasive.

A linear trendline is a reasonable first summary when the points follow an approximately straight pattern. A curved model may fit a clearly curved relationship, but adding complexity can also make a chart harder to interpret. In the Format Trendline pane, Excel can display the trendline equation and the R-squared value on the chart. R-squared describes how closely the fitted model accounts for variation in the plotted data under that model; it does not establish causation or guarantee that the model is appropriate. Avoid presenting a displayed equation as a general law beyond the observed range.

If the chart contains several series, make sure the trendline is attached to the intended series. A trendline summarizes that series, not necessarily all points in the chart. If the data has distinct groups, a single overall trendline can conceal different within-group patterns.

Read the pattern without overclaiming

Start by looking at direction, shape, and spread. Direction describes whether Y tends to rise or fall as X increases. Shape distinguishes a roughly straight pattern from a curve or multiple clusters. Spread describes how tightly the points sit around the general pattern. A narrow band may indicate a stronger association than a broad cloud, but the chart alone does not supply a complete statistical analysis.

Look for unusual points and ask whether they are valid measurements. An outlier can reflect a data-entry mistake, a special case, or a genuine observation that matters. Do not remove a point solely because it weakens the apparent relationship. Check the source and document any exclusion. Also consider whether the sample covers an appropriate range: a relationship visible across a broad range can look different when only a small portion is shown.

For a concrete example, imagine a table of advertising spend and weekly sales. A rising cloud of points may indicate that higher spending is associated with higher sales, but seasonality, discounts, store size, and other influences could also affect sales. The chart can help identify questions for further analysis; it cannot isolate the effect of advertising by itself.

Fix common scatter plot problems

If the chart shows one point, a flat line, or an unexpected shape, check the source data and series settings before changing the chart type. Common causes include numbers stored as text, incorrect X and Y ranges, blank cells, and selecting a header or unrelated column as part of the data. Use Chart Design > Select Data to inspect the ranges assigned to each series.

Points appear in the wrong places: Confirm that X and Y values come from the intended columns and that paired rows have not been separated.
The horizontal axis shows 1, 2, 3 instead of your measurements: Check that the chart is an XY scatter chart rather than a category-based chart, and verify the series X values.
Some observations are missing: Look for text values, blanks, errors, or cells outside the selected range. Extend the series ranges if new rows were added after chart creation.
Points overlap heavily: Reduce marker size, use transparency if available, or split meaningful groups into separate series. Do not interpret a dense patch as a single observation.
The pattern looks distorted: Review axis bounds and number formats in Format Axis. Make sure a manually narrowed scale is not exaggerating differences.

When blank or hidden cells affect a chart, select the chart and use Chart Design > Select Data, then choose Hidden and Empty Cells to review how Excel handles them. Options and availability can vary by chart and Excel release. Treat missing values thoughtfully: connecting across a gap can suggest measurements that were never recorded.

Scatter plots compared with other Excel charts

Use a scatter plot when both variables are numeric and the horizontal position should reflect numeric distance. If X values are 1, 2, and 10, the chart should leave a larger gap between 2 and 10 than between 1 and 2. A line chart, by contrast, typically treats horizontal entries as categories spaced evenly. That makes line charts useful for ordered categories or regularly sequenced observations, but they may be misleading when numeric X spacing matters.

A column or bar chart is often better for comparing amounts across named categories such as departments or products. A histogram is designed to show the distribution of one numeric variable, rather than the relationship between two variables. Choosing the chart type according to the data structure helps prevent a visually polished chart from implying the wrong kind of comparison.

Frequently Asked Questions

How do I make a scatter plot in Excel with two columns?
Put the X measurements in one column and the matching Y measurements in the next, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Add axis titles so readers know what the values represent.

Why is Excel using the first column as labels instead of X values?
The selected chart may be a line or other category-based chart rather than an XY scatter chart. Insert a scatter chart, then use Chart Design > Select Data to confirm that the series has the intended numeric X and Y ranges.

Can I make a scatter plot with more than one group?
Yes. Add a separate series for each group in Chart Design > Select Data, and assign each series its own X and Y ranges. Use distinct markers or colors and include a legend when it helps explain the groups.

Should I connect the dots in a scatter plot?
Only when the points have a meaningful order, such as successive measurements over time, and connecting them helps explain the data. For independent observations, markers without connecting lines are usually clearer because lines can imply a sequence or continuity that does not exist.

Does a trendline prove that X causes Y?
No. A trendline describes a fitted pattern in the plotted observations. Other variables, selection effects, or chance may explain some or all of the relationship, so a chart by itself cannot establish 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.