Scatter Plot Data in Excel: Create and Read Charts

Charts & pivot tables · Updated November 21, 2026

To create a scatter plot in Excel for Microsoft 365 on Windows, put numeric X values in one column and matching numeric 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, letting you see how two measured variables relate.

What a scatter plot shows

A scatter plot, also called an XY chart, places one numerical variable on the horizontal axis and another on the vertical axis. Each marker represents a single observation: its position is determined by that row’s X and Y values. For example, a shop might plot advertising spend on the X axis and weekly sales on the Y axis to see whether higher spending tends to accompany higher sales.

The pattern can reveal direction, form, and spread. Points that generally rise from left to right suggest a positive association; points that fall suggest a negative one. A shapeless cloud may indicate a weak relationship, while a curved pattern can show that a straight-line summary is inadequate. Outlying points may be worth checking, but they are not automatically errors: they can represent unusual yet valid observations.

A scatter plot shows association, not proof that one variable causes the other. Sales and advertising might move together because of seasonality, for instance. The chart is a useful exploratory tool, but conclusions need context and, where appropriate, further analysis.

Arrange the data before charting

Use one row per observation, with the X measurements in the first column and the corresponding Y measurements alongside them. Include clear column headings, and keep each pair on the same row. A small example might look like this:

  • A1: Study hours; B1: Quiz score
  • A2:B5: 1, 58; 2, 64; 3, 73; 4, 79

Here, Excel plots (1, 58), (2, 64), (3, 73), and (4, 79). The values do not need to be consecutive or evenly spaced. That is one reason an XY chart is useful: the horizontal positions reflect the actual numeric X values rather than treating each row as an equally spaced category.

Check that the cells contain numbers Excel recognizes as numbers. Text that looks numeric, blank cells, errors, or mismatched ranges can lead to missing or unexpected points. If observations are paired by date, person, product, or another identifier, verify the row alignment before charting; sorting only one column would break the pairs.

Create a basic scatter plot

  1. Arrange the X and Y data in adjacent columns and include headings in the top row.
  2. Select the headings and data cells, such as A1:B21. Including headings helps Excel name the series.
  3. Choose Insert > Insert Scatter (X, Y) or Bubble Chart.
  4. Under the Scatter options, choose the first chart type, typically Scatter (markers only), for a straightforward relationship plot.
  5. Use the chart elements button beside the chart, or the Chart Design tab, to add a title and axis titles that explain what the values measure.

The chart should show one marker for each complete pair of values. If the axes or series look wrong, select the chart and open Chart Design > Select Data. In the Edit Series controls, check that Series X values point to the intended X range and Series Y values point to the matching Y range. Avoid including the header cells in those numeric ranges if Excel has not handled them as labels.

Excel for Mac has a similar Insert workflow, although ribbon layout can differ slightly by release. Excel for the web also offers scatter charts, but some chart-formatting options are more limited or placed differently than in the desktop app.

Choose the right scatter chart type

The standard markers-only scatter chart is usually the clearest starting point. Other options connect points with straight or smooth lines, with or without markers. Connecting points is useful when the order of observations matters, such as measurements taken over time or along a physical path. It can mislead when the data are independent observations: the connecting line may imply a sequence or intermediate values that have no meaning.

A bubble chart is a related option that represents a third numeric variable through marker size. It can be useful when three measures need comparison, but bubble areas are harder to judge precisely than positions, and overlapping bubbles can hide data. Use it only when the extra dimension adds meaningful information.

Choose based on the question, not merely the appearance. If the horizontal values are categories such as product names, a column or line chart may be more suitable. A scatter plot expects numeric X positions and is designed to show the relationship between two quantitative variables.

Add another data series

Multiple series can compare groups, such as sales and costs or measurements from different locations. Each series needs paired X and Y values. If groups share the same X measurements, a common layout is one X column followed by one Y column per group. For reliable setup, add or edit each series explicitly rather than assuming Excel will infer every pairing correctly.

  1. Select the chart and choose Chart Design > Select Data.
  2. Choose Add to create a series.
  3. Enter or select the series name, then select the numeric range for Series X values and the matching range for Series Y values.
  4. Repeat for each group, making sure the X and Y ranges have the same number of observations and correspond row by row.

Use different marker colors or shapes to distinguish groups, and provide a legend if viewers need to identify them. If the groups contain many points, transparency or smaller markers can reduce visual clutter. Do not use color alone if the chart needs to remain easy to interpret when printed in grayscale.

Format axes and markers for clarity

Axis titles should state both the measure and, where relevant, its unit—for example, “Distance (km)” and “Travel time (minutes).” A descriptive chart title should say what is being compared rather than simply “Scatter Plot.” You can add or edit these from Chart Design > Add Chart Element or the chart elements button, depending on the ribbon layout.

To adjust an axis, right-click it and choose Format Axis. You can set bounds, units, number formats, and other axis options. Use sensible limits: narrowing an axis can make a small difference look dramatic, while an unnecessarily broad range can flatten meaningful variation. A logarithmic scale can help when values span several orders of magnitude, but it cannot display zero or negative values and should be clearly communicated.

Markers should remain visible without obscuring one another. In Format Data Series, adjust marker size, fill, and border. If the chart has only a few observations, labels may help; with hundreds of points, labels often overlap and make the plot harder to read. Keep gridlines subtle and remove decoration that does not help readers interpret the data.

Trendlines and what they mean

A trendline can summarize a pattern. Select a data series, then use Chart Design > Add Chart Element > Trendline to add an appropriate line, such as linear, exponential, or polynomial. The best choice depends on the data and the question; adding a higher-order curve simply because it fits the points closely can overstate a pattern that will not hold for new observations.

In trendline options, Excel can display the equation and the R-squared value on the chart. R-squared describes how closely the fitted model accounts for variation in the plotted observations; it does not establish causation, prove that the model is appropriate, or guarantee accurate predictions outside the observed range. A high value can coexist with influential outliers or a misleading model choice. Inspect the point pattern and the underlying context alongside any statistic.

Common problems and practical fixes

  • Excel uses row numbers or the wrong values for X: Open Select Data and edit the series so the X and Y ranges are assigned explicitly.
  • The chart has no points or only some points: Check for text-formatted numbers, blank cells, errors, and unequal X and Y range lengths.
  • Points appear in the wrong pairs: Confirm that each X value remains on the same row as its corresponding Y value. Sort the full table, not an individual column.
  • The plot looks like evenly spaced categories: Confirm that the chart type is Scatter (X, Y), not a line chart. A line chart treats its horizontal axis as categories.
  • Several groups become one series: Use Select Data to add separate series and specify each X and Y range.
  • Too many points overlap: Reduce marker size, use transparency, split groups into separate charts, or summarize the data carefully without hiding important variation.

Sorting the complete dataset by X can make a connected scatter chart easier to follow, but it is not required for a markers-only scatter plot. In fact, sorting is not a substitute for fixing incorrect pairings. When comparing observations in time order, decide whether the time sequence itself matters; a scatter plot can show relationships, while a line chart may communicate chronological change more naturally.

Frequently Asked Questions

How do I make a scatter plot in Excel with two columns?
Select the two columns, with X values first and matching Y values second, then choose Insert > Insert Scatter (X, Y) or Bubble Chart and select a scatter chart. Check the series settings if Excel assigns the axes incorrectly.

Can a scatter plot in Excel have more than one data series?
Yes. Use Chart Design > Select Data > Add, then assign the X and Y ranges for each series. The ranges should contain corresponding observations and have the same number of values.

What is the difference between a scatter plot and a line chart in Excel?
A scatter plot uses numeric X values and spaces points according to their values. A line chart uses a category axis, commonly with evenly spaced labels. Use scatter for relationships between two numeric measures; use a line chart when category order, often time, is central.

How do I add a trendline to an Excel scatter plot?
Select the plotted series and choose Chart Design > Add Chart Element > Trendline, then select a suitable model. Treat the line as a summary of the observed data, not evidence of cause or a guarantee about future values.

Why is my Excel scatter plot showing the wrong axes?
Excel may have guessed the series mapping incorrectly. Open Chart Design > Select Data, edit the series, and set Series X values and Series Y values to the intended numeric ranges. Confirm that each pair is on the same row.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.