Scatter Plot in Excel: Step-by-Step Setup and Formatting

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 > Scatter. Select the markers-only option, then add axis titles and adjust the chart as needed.

What a scatter plot shows

A scatter plot, also called an XY chart, places each paired observation at a position determined by two numeric values: one on the horizontal X axis and one on the vertical Y axis. For example, a teacher might plot hours studied against exam scores to see whether the two measurements tend to move together. Each dot represents one student’s pair of values.

This chart is useful for spotting relationships, clusters, gaps, and unusual observations. A general upward pattern suggests that larger X values are often associated with larger Y values; a downward pattern suggests the reverse. A scattered cloud with no clear direction may indicate a weak relationship, though the chart alone cannot establish why a pattern exists.

Unlike a column chart, a scatter plot uses the numerical distance between X values. A point at X = 20 is positioned twice as far from zero as a point at X = 10. That makes it a good choice when both variables are measurements, such as time, distance, temperature, price, or test scores.

Prepare the data before charting

Put each observation on one row, with the X measurement in the first column and its matching Y measurement beside it. Use a header row to identify the variables, and avoid blank rows within the data. For example, a small study-hours dataset could look like this:

A1: Hours studied; B1: Exam score
A2:B5: 1, 58; 2, 67; 3, 73; 5, 88

Each row must describe one paired observation. If you sort one column independently, you break the pairings and the chart will no longer represent the original data. Select and sort the complete table instead. Scatter plots do not require the X values to be sorted for the dots to appear correctly, but sorting can make the worksheet easier to inspect.

Check that the values are numbers rather than text that only looks numeric. Imported values may contain leading apostrophes, spaces, or inconsistent decimal separators. Excel may also treat a blank cell differently from zero: a zero is a real plotted value, while a blank is missing information. Do not replace missing measurements with zero unless zero is genuinely what was measured.

Create a basic scatter plot step by step

Select the two columns of data, including their headers. If the columns are adjacent, select the full range, such as A1:B5. Keeping X on the left and Y on the right helps Excel assign the intended axes.
Open the Insert tab on the ribbon.
Choose Insert Scatter (X, Y) or Bubble Chart in the Charts area.
Choose the first scatter option, usually labeled Scatter or shown as markers without connecting lines. Excel inserts the chart into the worksheet.
Click the chart title and type a useful title, such as “Study Hours and Exam Scores.” If a title is not shown, select the chart and use Chart Design > Add Chart Element > Chart Title > Above Chart.
Add axis titles through Chart Design > Add Chart Element > Axis Titles, then select the horizontal and vertical titles on the chart and replace the placeholder text.

For the example, label the horizontal axis “Hours studied” and the vertical axis “Exam score.” These labels tell readers what the numbers mean and which measurement is assigned to each direction. The chart title should describe the relationship rather than merely say “Scatter Plot.”

In Excel for Mac, the chart is also created from the Insert tab using the scatter chart options; the ribbon layout can look different by version. Excel for the web has chart insertion and basic formatting, but some chart-editing controls may be arranged differently or less extensively than in the Windows desktop app.

Format axes and make the chart readable

Axis scales affect how a pattern looks, so check the bounds and intervals rather than accepting every default without thought. Right-click an axis and choose Format Axis to open its settings. In the pane, you can set minimum and maximum bounds, major units, number formats, and other axis options. In the example, scores might reasonably run from 0 to 100; a narrower scale can make small differences look more dramatic, so use a scale that fits the purpose and remains clear.

Keep labels readable and use a simple design. A few horizontal gridlines can help readers estimate values, while excessive gridlines, decorative effects, and bright backgrounds can distract from the data. If the chart is crowded, enlarge it or reduce the number of decimal places shown on the axes. You can change marker appearance by selecting a data point or series and opening Format Data Series.

When X values are dates, a scatter plot treats them as numeric date values and spaces them according to elapsed time. That can be helpful when observations are unevenly spaced. If you want dates displayed as dates rather than serial numbers, use Format Axis and choose an appropriate date number format. If every date should instead appear as an equally spaced category, a line chart may be a better fit.

Add more than one data series

To compare groups, such as scores from two classes, give each group its own X and Y pairs. A reliable way to add a series is to select the chart, open Chart Design > Select Data, and choose Add. Enter a series name, then specify the cells for that series’ X values and Y values in the dialog. The ranges should contain matching numbers of observations.

For example, one series could show study hours and scores for Class A, while another shows the same two measurements for Class B. Format the series with distinguishable marker colors or shapes, and display a legend so viewers can identify them. Avoid adding so many groups that the marks overlap into an unreadable mass. If two groups have many similar values, use transparency or different marker shapes where available, or split them into separate charts.

When selecting several columns at once, Excel may guess how to divide them into series. If it assigns the wrong X or Y range, use Select Data to edit the series rather than rebuilding the chart. For a scatter series, verify both ranges explicitly: the X values control horizontal position, and the Y values control vertical position.

Trendlines and what the pattern means

A trendline can summarize a broad pattern, but it does not replace the points themselves. To add one, select a data series and use Chart Design > Add Chart Element > Trendline, then choose an appropriate type, such as Linear. A linear trendline is most suitable when the relationship looks roughly straight. Curved patterns may require another model, and a trendline should not be selected merely because it makes the chart look more polished.

Excel can show an equation or an R-squared value for some trendlines through the trendline formatting options. Treat these as summaries that depend on the chosen model and the data included. A high R-squared value does not prove that X causes Y, and a visible association may reflect another factor. For instance, a relationship between ice-cream sales and swimming incidents could arise because both increase in warm weather, not because one directly causes the other.

Inspect individual points as well as the overall direction. One extreme value can strongly affect a fitted line, and clusters may represent different groups that should not be combined. Investigate unusual values in the source data before deciding whether they are errors or meaningful observations.

Common problems and quick fixes

The axes seem reversed: Open Chart Design > Select Data, edit the series, and check the X and Y ranges. Confirm that the values you intend as X are assigned to the horizontal axis.
The chart shows one point or an unexpected series: Check the selected range, headers, and cell contents. Use Select Data to correct the series ranges if Excel guessed incorrectly.
Points are missing: Look for blanks, text-formatted numbers, or filtered-out data. Confirm whether blanks should remain missing rather than being converted to zero.
The chart connects points in a surprising order: You may have selected a scatter subtype with lines. Choose the markers-only scatter subtype if you want independent points without connecting segments.
The points overlap: Use smaller markers, distinguish series, or make separate charts. Overlap can hide how many observations share similar values.

If a chart is wrong, correct the source data or series ranges first. Formatting cannot repair a mistaken pairing between X and Y values.

Scatter plot versus line chart

Both chart types can show data points and lines, but they treat the horizontal axis differently. A scatter chart uses a numeric X axis with meaningful spacing between values. A line chart generally places categories at evenly spaced positions, even if the category labels are dates or numbers with unequal gaps.

Choose a scatter plot for paired numeric measurements, especially when X values are irregularly spaced or when you want to examine a relationship between two variables. Choose a line chart when the main purpose is to show a sequence, such as monthly totals, with each time period treated as a successive category. For example, measurements taken on days 1, 2, and 30 have a long gap before day 30 on a scatter chart; a category-based line chart may space those three labels evenly.

Connecting points on a scatter plot is possible, but the line follows the order of rows in the source data. Sort by X first if that is the intended path. If each point is an independent observation, markers alone are usually less misleading.

Frequently Asked Questions

How do I change the X-axis values in an Excel scatter plot?
Select the chart, go to Chart Design > Select Data, select the series, and choose Edit. Replace the series’ X values range with the correct cells, then confirm that its Y values range is still correct.

Can an Excel scatter plot have more than one series?
Yes. Use Select Data > Add to add each group as a separate series, with its own X and Y ranges. Give each series a clear name and use a legend when readers need to distinguish the groups.

Why does Excel show my numbers as categories?
You may have inserted a line or another category-based chart instead of an XY scatter chart. Create a chart using the scatter options under Insert Scatter (X, Y) or Bubble Chart, then verify the series ranges.

Can I use dates on a scatter plot?
Yes. Excel stores dates as numbers, so dates can be used for X values and spaced according to elapsed time. Format the horizontal axis to display dates clearly; use a line chart instead if equal spacing between date categories is what you need.

Does a trendline prove that one variable causes another?
No. A trendline summarizes an association in the plotted data. Other variables, selection effects, or chance can explain a pattern, so causal claims need evidence beyond the chart.

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.