To make a scatter plot in Microsoft Excel for Microsoft 365 on Windows, arrange each observation’s X value and Y value in separate numeric columns, 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 numerical variables relate.
What an Excel scatter plot shows
A scatter plot, also called an XY chart, places one numerical variable along the horizontal X axis and another along the vertical Y axis. Every paired set of values becomes a point. For example, a point might represent one month’s advertising spend on the X axis and sales revenue on the Y axis. A pattern rising from lower left to upper right suggests the variables tend to increase together; a downward pattern suggests one tends to decrease as the other increases.
Unlike a chart that uses categories, a scatter plot treats the horizontal values as numbers with measurable distances between them. If one X value is 10 and another is 20, Excel places the second point twice as far from zero as the first, subject to the axis scale. This is useful for exploring relationships, clusters, unusual observations, and possible trends. It does not, by itself, establish that one variable causes another.
When to use a scatter plot
Choose a scatter plot when both variables are quantitative and each row represents a matched pair. Common examples include height and weight, temperature and energy use, study time and test scores, or product price and units sold. It is especially helpful when the X values are unevenly spaced, such as measurements taken at 1, 2, 5, and 10 minutes. The chart preserves those actual intervals.
A scatter plot is less suitable when the horizontal axis consists of named categories such as departments or product types. For category comparisons, a column or bar chart is usually clearer. If you want to show values across equally spaced labels or dates and emphasize their sequence, a line chart may be a better choice. The key question is whether the X values represent numerical positions or merely labels.
Prepare the worksheet data
Put each observation on one row, with the X variable in one column and its paired Y variable in another. Use clear headers in the first row, and avoid blank rows inside the data. For example, a worksheet could have Month in column A, Advertising spend in column B, and Sales in column C. To plot spend against sales, use B and C; the month can remain a label or be used separately for identifying points.
- Make sure the X and Y values on a row refer to the same observation. Sorting one column independently can break the pairings.
- Use numbers rather than numbers stored as text. Excel may treat text entries as missing or fail to position them as expected.
- Keep units consistent within a variable. Do not mix dollars and thousands of dollars in the same series without converting one set.
- Leave descriptive headers above the values. Excel can use these as series names when building a chart.
- Check for blanks, errors, and implausible values before interpreting a pattern. A single mistaken value can stretch an axis and compress the rest of the points.
Dates can be used as X values because Excel stores dates as serial numbers. If the goal is to compare observations at real time intervals, this can be useful. If the dates are only labels for a sequence, a line chart may be easier to read.
Create the chart in Excel for Windows
- Select the two numeric columns, including their headers, if they are next to each other. Selecting the full data range helps Excel identify the series name.
- Open the Insert tab, choose Insert Scatter (X, Y) or Bubble Chart, and select the basic Scatter option with markers. This option displays points without connecting lines.
- Click the chart and check that the horizontal axis shows the intended X variable and the vertical axis shows the intended Y variable.
- Use Chart Design > Add Chart Element > Axis Titles to add horizontal and vertical titles. Replace the placeholder text with the variable names and units.
- Use Chart Design > Add Chart Element > Chart Title to give the chart a specific title, such as Advertising Spend and Monthly Sales.
If your columns are not adjacent, or Excel assigns the wrong values to an axis, insert a blank scatter chart and define the series directly. Select the chart, go to Chart Design > Select Data, and choose Add. In the Edit Series dialog, provide a series name if useful, then select the appropriate cell range for Series X values and Series Y values. Exclude the header cells from the value ranges, and use ranges with the same number of observations. This explicit method is often the clearest way to control what Excel plots.
Format axes and markers for readability
Click an axis and open Format Axis to adjust its scale, bounds, units, number format, and other available settings. Excel usually chooses an automatic scale that includes the data. Set minimum or maximum bounds only when there is a good reason, such as comparing several charts on the same scale. A truncated axis can make a small difference look dramatic, so make the scale choice visible and deliberate.
Axis titles should name both the measure and its unit, for example Distance (km) and Time (minutes). To change point appearance, select a marker and use Format Data Series to adjust marker size, fill, or border. Smaller markers can help when many points overlap; transparency can also reveal dense areas. Keep gridlines subtle enough that they guide reading without competing with the data.
For a useful pattern summary, select the series and choose Chart Design > Add Chart Element > Trendline, then choose a suitable type, such as Linear. A trendline summarizes an overall direction; it does not mean every point follows a straight-line relationship. You can display the equation or R-squared value through the trendline’s formatting options, but these statistics should be interpreted in context rather than treated as proof of causation or a guarantee of future results.
Plot multiple series and identify points
To compare groups, add one series for each group, such as one series for each store or product category. Each series needs its own X and Y ranges. In Chart Design > Select Data, use Add to create another series and assign its ranges. Give each series a meaningful name, then use distinguishable marker colors or shapes and keep the legend visible if readers need to identify groups.
Use separate series when group membership is important to the question. For example, plotting test scores against study hours for two classes may show whether their patterns differ. Avoid adding so many colors that the chart becomes hard to decode. When points overlap heavily, consider smaller markers or a different view, and remember that a scatter plot can hide how many observations occupy the same location.
To add context for a single point, you can use a data label, though labeling every point often creates clutter. A practical alternative is to label only notable points or add a nearby note explaining an outlier. For a chart that changes as rows are added, format the source data as an Excel table before creating the chart; charts based on table data generally expand as new table rows are entered, though it is wise to confirm the series ranges when the chart is important.
Common scatter plot problems
- The axes are reversed: Edit the series through Chart Design > Select Data and check the Series X values and Series Y values fields. A scatter chart’s X values are not simply category labels.
- Points are missing: Check whether values are blank, stored as text, or contain errors. Confirm that the selected ranges include the intended rows and that the X and Y ranges have matching lengths.
- All points appear in a narrow strip: One unusually large value may be expanding the axis range. Inspect the data before changing the scale; do not remove a valid observation just to make the chart look more dramatic.
- The chart connects points unexpectedly: Select the marker-only Scatter subtype, rather than a scatter subtype with straight or smooth lines. Lines can imply an ordered path that may not make sense for independent observations.
- Dates or labels look strange: Confirm that the X values are valid Excel dates or numbers. If the horizontal dimension is a list of categories rather than a measurement, switch to a chart type designed for categories.
- The trendline seems misleading: Look for curved patterns, clusters, and outliers. A linear trendline can obscure a nonlinear relationship or a difference between groups.
When in doubt, inspect a few plotted points against their worksheet rows. This simple check can reveal swapped columns, mismatched ranges, or a mistaken sort before the chart is shared.
Scatter plot versus line chart
Both chart types can show two numerical-looking dimensions, but they treat the horizontal axis differently. In a scatter plot, X values are numeric positions, and the gaps between values determine the spacing between points. In a line chart, the horizontal axis is commonly a category axis, so labels can be spaced evenly even when the underlying dates or values are not equally spaced.
Use scatter when the spacing itself matters or when you want to test the relationship between two measurements. Use a line chart when the main story is an ordered sequence, such as weekly sales over time, especially if every week should occupy one equal step. A line chart can be a strong time-series display, while an XY chart is better for examining the measured distance between time values or another numerical X variable.
Frequently Asked Questions
How do I add a trendline to an Excel scatter plot?
Select the chart, then choose Chart Design > Add Chart Element > Trendline and select a type such as Linear. You can also use the chart’s elements controls where available. Check whether the chosen model suits the visible pattern.
Can a scatter plot have more than one data series?
Yes. Add a series through Chart Design > Select Data > Add, then assign its X and Y ranges. Use clear series names and distinct markers so readers can tell groups apart.
Why is Excel using the wrong column for the X axis?
Excel may infer the series incorrectly from the selected layout. Open Chart Design > Select Data, edit the series, and assign the intended ranges to Series X values and Series Y values.
Should I use a scatter plot or a line chart for dates?
Use a scatter plot if actual time intervals matter, such as irregular measurement dates. Use a line chart if dates represent an ordered sequence and equal spacing between observations is more useful than showing exact elapsed time.
Does a scatter plot prove that one variable causes another?
No. A visible association shows that two variables vary together in the displayed data, but other variables or chance may explain the pattern. Establishing causation requires suitable study design and evidence beyond the chart.
Related
- How to Split a Cell in Excel: Text, Columns, and More
- How to Run Scenario Manager in Excel
- How to Run Goal Seek in Excel to Find a Target Value
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table: How to Exclude Specific ValuesTo exclude values from an Excel PivotTable, open the drop-down for the field containing them, clear the checkboxes…
- Excel Time Charts: Plotting Dates, Times, and TrendsTo make an Excel time chart, put each date or time in one column and its measurement in…
- Can You Make a Stacked Waterfall Chart in Excel?Yes—but Excel does not provide a native chart type that combines stacked components with waterfall steps. In Microsoft…
- Bar Chart Formula in Excel: How to Create OneThere is no special Excel formula that creates a bar chart: a chart is an object you insert…
- Power Pivot in Excel: What It Does and How to Use ItPower Pivot is Excel’s data-modeling feature: it lets you connect and relate multiple tables, create calculations with the…
- Add an Upper Limit Line to an Excel ChartTo add an upper limit line to an Excel chart, create a helper series whose value repeats the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.