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

To create a scatter plot in Excel for Microsoft 365 on Windows, put your X values in one column and matching Y values in the next, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart and pick a scatter option. Excel plots each row as an X-Y pair; add axis titles and, if useful, a trendline to make the relationship easier to understand.

What a scatter plot shows

A scatter plot, also called an XY chart, places one numeric variable on the horizontal axis and another numeric variable on the vertical axis. Every plotted marker represents a pair of measurements. For example, a point might show that a plant received 6 hours of light and grew 14 centimeters. Looking across many points can reveal whether the variables tend to rise together, move in opposite directions, or show little visible association.

Unlike a chart that treats its horizontal labels as categories, an XY scatter plot uses the actual numeric spacing between X values. If measurements were taken at days 1, 2, and 10, the gap from day 2 to day 10 is shown as larger than the gap from day 1 to day 2. This makes scatter plots useful for measurements such as time, distance, price, temperature, and test scores.

A visible pattern is evidence of association, not proof that one variable caused the other to change. A third factor could influence both variables, and a strong-looking relationship in a small sample may not hold in a larger one. Treat the chart as a way to explore and communicate data, not as a substitute for sound study design.

Prepare the data in two columns

Arrange the data so each row contains one complete observation. Put the proposed X variable in the first column and the paired Y variable in the second. Include a short header above each column, such as Hours Studied and Test Score. Keep the values numeric rather than storing numbers as text, and avoid blank rows within the data.

For example, a small study-hours dataset might have these pairs: (1, 55), (2, 61), (3, 68), (4, 72), and (6, 84). The first number in each pair is hours studied; the second is a score. Excel will plot five markers, one for each row. The example suggests a positive association, but five observations are not enough by themselves to establish a general rule.

Keep the X and Y values for an observation on the same row. Sorting one column independently breaks the pairings.
Use one header row and make headers descriptive. Excel may use these names in the legend or chart labels.
Check for numbers stored as text, stray spaces, and error values. They can prevent Excel from plotting a point as expected.
If you have several Y measurements for the same X values, add each Y series in its own column and give it a clear header.

For the simplest chart, put the two columns next to each other and select the headers and data. If columns are separated, you can select a nonadjacent range by holding Ctrl while selecting on Windows, or Command on Mac. For a first chart, adjacent columns are usually easier to inspect and edit.

Create the scatter plot

Select the two columns, including the headers and all paired rows.
On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart.
Choose Scatter (the option with markers and no connecting lines) for a standard point chart. Other choices include scatter with smooth lines and markers, scatter with straight lines and markers, and versions with lines but no markers.
Click the chart title and type a specific description, such as Study Hours and Test Score. If the chart has no title, use Chart Design > Add Chart Element > Chart Title.

The standard markers-only option is a good starting point because it emphasizes individual observations without implying that values between them were measured. Excel inserts the chart on the worksheet. You can drag it to reposition it and use its corner handles to resize it. To make a separate chart sheet, use Chart Design > Move Chart and choose New sheet.

If Excel places the wrong column on an axis, do not rebuild the table immediately. Select the chart, then choose Chart Design > Select Data. Select the series and choose Edit. In the Edit Series dialog, set Series X values to the numeric X range and Series Y values to the matching numeric Y range; exclude the header cells from these ranges. This is also where you can add or remove series.

Label and format the axes

Axis titles tell readers what each scale measures and, when relevant, its unit. Select the chart and choose Chart Design > Add Chart Element > Axis Titles > Primary Horizontal, then repeat for Primary Vertical. Click each placeholder and enter a label such as Hours studied or Score out of 100. A chart title alone is not enough if readers cannot tell what the axes mean.

To change an axis scale, right-click the axis and choose Format Axis. In the Format Axis pane, you can set bounds and units, and adjust number formatting. Excel normally chooses a scale automatically. Change it only when a clear reason exists: for example, a known measurement range or a need to compare charts on the same scale. Setting the minimum to a value above zero can make modest differences look dramatic, so disclose or carefully justify that choice.

For marker appearance, select a point and open Format Data Series. The pane lets you adjust marker options, including shape, size, fill, and border. Use a size that makes individual points visible without making overlapping points look like a single solid mass. If you have multiple series, use distinct colors or marker shapes and keep the legend clear. Avoid decorative effects that compete with the data.

Gridlines can help readers estimate values, but too many can clutter a chart. Use the chart’s Chart Design > Add Chart Element > Gridlines options to add or remove them. A readable chart generally has a concise title, labeled axes, an appropriate scale, and enough visual contrast to distinguish points. Keep the formatting consistent if the chart will be compared with others in a report.

Add a trendline and interpret the pattern

A trendline summarizes a broad pattern; it does not pass through every observation. To add one, select the chart, then choose Chart Design > Add Chart Element > Trendline > Linear. You can also right-click a plotted series and choose Add Trendline. In the Format Trendline pane, select a different type only when the shape of the data and the subject matter support it. A polynomial or other curved fit can follow bends, but an unnecessarily flexible line can make random variation look meaningful.

A linear trendline slopes upward when larger X values generally accompany larger Y values, and downward when larger X values generally accompany smaller Y values. A nearly flat line indicates little linear change in Y across the displayed X range. The scatter itself matters: a line can summarize the direction while hiding clusters, outliers, or a curved pattern. Inspect the points rather than treating the trendline as the whole result.

Excel can display a trendline equation and an R-squared value through options in the Format Trendline pane. R-squared describes how closely the fitted line accounts for variation in the plotted Y values under the model used; it is not the chance that the relationship is true, and it does not establish causation. A high value does not make an inappropriate model appropriate. Avoid reporting more precision than the measurements support.

Common scatter plot problems

Excel treats X values as labels or plots them in the wrong order. Confirm that you inserted an XY scatter chart rather than a line chart. Then check the series’ X and Y ranges in Chart Design > Select Data > Edit.
The chart has only one point or no useful points. Check whether the selected ranges include all rows, whether the values are numeric, and whether the X and Y ranges contain the same number of cells. Remove accidental blank or text entries where appropriate.
Points sit on top of one another. Duplicate observations can overlap exactly. Consider smaller markers, transparency if available in the formatting options, or a different charting approach when showing concentration is important. Do not alter the data merely to make the chart look clearer.
The trendline looks misleading. Check for a curved pattern, distinct groups, or an influential outlier. A single line may not describe all parts of the data. Review the source measurements before deciding whether an observation is an error; do not delete a valid point just because it changes the line.
Blank cells appear at zero or make unexpected marks. Inspect the source range for formulas returning zero, cells containing text, and truly empty cells. For chart handling options, select the chart and use Chart Design > Select Data > Hidden and Empty Cells, where available. Choose an option that reflects what missing measurements mean rather than silently treating them as measured zeros.

When dates are used as X values, check that Excel recognizes them as dates rather than text. A scatter chart uses their underlying numeric date values, so the spacing reflects elapsed time. If labels look like serial numbers, format the horizontal axis through Format Axis and choose a suitable date number format.

Scatter plot or line chart?

Choose a scatter plot when both variables are numeric and the horizontal variable’s actual values and intervals matter. It is especially suitable when X values are unevenly spaced, observations are independent pairs, or you want to study how one measurement varies with another. A line chart is generally better when the horizontal axis represents an ordered sequence of categories, such as months, and the main goal is to show a continuous progression across those categories.

Although a line chart can display dates or numbers, its horizontal axis is often a category axis, where labels may be spaced evenly regardless of the real interval between values. A scatter chart instead places points according to numeric X values. Connecting scatter points with lines can be useful for ordered measurements, but it can imply continuity or sequence. For unrelated observations, markers without connecting lines are usually clearer.

Frequently Asked Questions

How do I make a scatter plot in Excel with two columns?
Select both columns, including headers, then choose Insert > Insert Scatter (X, Y) or Bubble Chart and select the markers-only scatter option. Check that the first column is the intended X variable and the second is Y; if not, edit the series under Chart Design > Select Data.

How do I add a line of best fit in Excel?
Select the scatter chart and choose Chart Design > Add Chart Element > Trendline > Linear. The resulting line is a fitted summary of the relationship, not a line that must pass through every point. Review the shape and distribution of the data before interpreting it.

Can a scatter plot have more than one data series?
Yes. Each series can have its own X and Y ranges. Use Chart Design > Select Data > Add, then enter a series name and matching X and Y ranges. Distinguish series with clear labels and accessible marker styles, and verify that each pair of ranges refers to the same observations.

Why does my Excel scatter plot show the wrong X-axis values?
The series may be using the wrong X range, or the chart may be a line chart instead of an XY scatter chart. Choose Chart Design > Select Data, edit the series, and inspect the Series X values and Series Y values boxes. Confirm that both ranges have matching lengths and exclude their headers.

Can I make a scatter plot in Excel on a Mac?
Yes. Excel for Mac includes XY scatter charts. Select the paired columns and use the Insert tab’s scatter chart option; ribbon labels and dialog layout can vary slightly by Excel release. When selecting nonadjacent ranges, use Command rather than Ctrl on Mac. The underlying chart setup is the same.

When should I not use a scatter plot?
A scatter plot is not the clearest choice when the horizontal values are categories with no meaningful numeric distance, or when you need to show a small number of category totals. A column or line chart may communicate those comparisons more clearly. If many points overlap, consider whether a different visualization can show density without obscuring the underlying measurements.

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.