To make a scatter plot in Excel for Microsoft 365 on Windows, place your X values in one column and corresponding Y values in the next, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter with only Markers. Add a chart title and axis titles so readers can tell what the points represent.
What a scatter plot shows
A scatter plot, also called an XY chart, places each row of paired numerical values on a coordinate plane. Excel uses the first selected numeric column for horizontal positions (X) and the second for vertical positions (Y). Each row becomes a point. For example, a table of daily temperatures and ice-cream sales could show whether higher temperatures tend to occur alongside higher sales.
Scatter plots are useful for checking relationships, clusters, gaps, and unusual observations. They do not prove that one variable causes another. A pattern may be influenced by a third factor, and a few extreme values can make a relationship look stronger or weaker than it is. Treat the chart as a way to inspect data, not as a substitute for understanding how the data was collected.
Use numerical measurements for both axes when the distance between values matters. If the horizontal values are categories such as months or product names, a line or column chart may be a better fit, depending on the question you want the chart to answer.
Prepare the data in two columns
Set up the data with one observation per row. Put the variable you want on the horizontal axis in the left column, and its paired measurement in the right column. Include a short header in each column, such as Temperature (°C) and Sales (units). Excel can use these headers in the chart legend or titles, and clear labels make later editing easier.
For instance, a small sample might have temperature values of 12, 18, 24, and 30 in column A, with corresponding sales of 15, 22, 31, and 43 in column B. The pairing is essential: the sales figure in a row must belong to the temperature value beside it. Sorting one column independently breaks those pairs and changes the meaning of every point.
- Keep X and Y values numeric. Values stored as text may be ignored or plotted unexpectedly.
- Use consistent units and measurement periods. Do not mix Celsius and Fahrenheit, or weekly and daily totals, without converting or clearly separating them.
- Keep headers in the first row and avoid merged cells inside the data range.
- Check for blank cells, error values, and duplicate records before charting. Decide whether missing measurements should remain blank or be excluded; do not replace them with zero unless zero is genuinely what was measured.
If the X and Y columns are separated by other fields, copy them into two adjacent columns on a separate worksheet or in an unused area. This simple arrangement makes Excel’s initial series assignment easier to verify.
Create the scatter plot in Excel
- Select both columns, including their headers. If there are no headers, select only the numeric values.
- Open the Insert tab on the ribbon.
- Choose Insert Scatter (X, Y) or Bubble Chart in the Charts group.
- Select Scatter with only Markers for a standard point chart. Excel inserts the chart on the worksheet.
- Check that the horizontal axis shows the intended X values and the vertical axis shows the intended Y values. If the axes are reversed, edit the series rather than rearranging the meaning of the data.
Excel may position the chart over cells near the selected range. Drag its border to move it, or drag a corner handle to resize it. To place it on its own sheet, select the chart and use Chart Design > Move Chart, then choose New sheet. This is useful when the chart needs more room or will be printed separately from the source table.
On Excel for Mac, the basic workflow is similar: select the paired columns, open Insert, and choose an XY scatter chart from the chart options. Ribbon labels and the layout of chart controls can vary slightly by release. Excel for the web also supports scatter charts, although some detailed formatting controls may differ from the Windows desktop app.
Label and format the axes
A useful chart identifies both variables and their units. Select the chart, then choose Chart Design > Add Chart Element > Axis Titles > Primary Horizontal and repeat for Primary Vertical. Click each title box and enter a concise label such as Temperature (°C) or Sales per day. Add a chart title through Chart Design > Add Chart Element > Chart Title. In some layouts, a plus-shaped Chart Elements button beside the selected chart offers the same elements.
To change the scale, right-click an axis and select Format Axis. In the Format Axis pane, you can set bounds and major units. A zero minimum is not mandatory for a scatter plot: choose bounds that show the data clearly, but avoid narrowing the range in a way that exaggerates small differences. If values span very different magnitudes, a logarithmic scale may help, but it changes how distances appear and cannot represent zero or negative values.
You can also adjust marker appearance. Select a point or the data series, open Format Data Series, and use the marker options to change marker shape, size, fill, or border. Use a size and color that remain legible when the chart is printed or viewed at a small size. A simple chart with one clear marker style is often easier to interpret than one with decorative effects.
Add another data series or a trendline
To compare groups, add a separate series for each one—for example, one series for a morning shift and another for an evening shift. Select the chart and choose Chart Design > Select Data. In the Select Data Source window, choose Add, then specify the series name, X values, and Y values in the Edit Series window. The X and Y ranges must have matching numbers of observations. Give each group a distinct marker color or shape and make the legend labels meaningful.
A trendline can summarize the general direction of a series. Select a series, then choose Chart Design > Add Chart Element > Trendline and select a suitable type, such as Linear. A linear trendline is appropriate only when a straight-line relationship is a reasonable summary; Excel also offers other trendline types, but selecting one should reflect the data and the question, not simply make the chart look smoother.
For a linear trendline, Excel can show the equation and the R-squared value on the chart through the Format Trendline pane. R-squared describes how closely the fitted line accounts for variation in the displayed data under that model. It is not a measure of causation, does not establish that the model is appropriate, and should not be treated as a universal score of data quality.
How to read the pattern responsibly
Start by looking at the overall shape. Points that generally rise from left to right suggest a positive association; points that fall suggest a negative association; a shapeless cloud may indicate little or no clear relationship. A curved band can reveal that a straight-line summary misses an important pattern. Separate clusters may indicate different groups or conditions that should be investigated rather than combined without explanation.
Look for outliers—points far from the main cluster—and verify them against the source data. They may be genuine unusual cases, data-entry errors, or measurements made under different conditions. Do not remove a point solely because it makes the trendline less tidy. If you exclude data, document the reason and, where relevant, compare conclusions with and without that observation.
Remember that a scatter plot displays association, not causation. If two measurements move together, that alone does not show that changes in one produce changes in the other. Consider sample size, the way observations were gathered, and possible confounding variables before drawing conclusions.
Common scatter plot problems and fixes
- The chart looks like a line chart: Check that you chose an XY scatter chart, not a Line chart. A line chart generally treats horizontal positions as categories, whereas a scatter chart uses numeric X values and spaces points according to their values.
- Points appear in the wrong places: Select the chart and use Chart Design > Select Data, then edit the series to confirm the correct X and Y ranges. A frequent cause is selecting a header or unrelated column as part of a series.
- The horizontal axis shows 1, 2, 3 instead of your measurements: Excel may not have assigned the X range as intended. Edit the series in Select Data and set the X values to the numeric X column.
- Some points are missing: Check whether the relevant cells contain text, blanks, or errors. Confirm that Excel has not interpreted numbers with a different decimal separator as text. Also inspect the selected range to make sure it includes all data rows.
- The chart is misleadingly compressed or dramatic: Review the axis bounds and units in Format Axis. A very wide range can compress most points into a small area; an extremely narrow range can make minor variation appear substantial.
- There are too many overlapping points: Use smaller markers, transparency where available in the formatting controls, or separate the data into meaningful groups. If many records share the same coordinates, some points may sit directly on top of others and be invisible.
Scatter plot versus line chart
Both chart types can show a sequence of measurements, but they treat the horizontal axis differently. A scatter plot uses numerical X values and places each point according to its actual value. If X values are 1, 2, 10, and 20, the gaps on the axis reflect those differences. A line chart typically spaces its categories evenly, even when labels represent dates or numbers with unequal intervals.
Choose scatter when both variables are quantitative and the spacing between X values matters—for example, distance versus travel time or dosage versus measured response. Choose a line chart when the main purpose is to show a sequence across evenly ordered categories, such as monthly totals, and category spacing is intended to be uniform. For dates with irregular gaps, an XY chart can be more faithful to elapsed time, provided the dates are valid Excel date values.
Frequently Asked Questions
How do I make a scatter plot with two columns in Excel?
Select the two adjacent columns, including headers if present, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter with only Markers. The first numeric column supplies X values and the second supplies Y values.
How do I switch the X and Y axes?
Select the chart and choose Chart Design > Select Data. Edit the series and assign the desired numeric range to Series X values and the other range to Series Y values. Changing the axis titles alone does not swap the plotted data.
Can I make a scatter plot with multiple groups?
Yes. Add each group as a separate series through Chart Design > Select Data > Add, then specify its name and matching X and Y ranges. Use distinguishable markers and a clear legend so readers can identify each group.
Why does Excel show a straight line between my points?
You may have selected a scatter subtype with straight lines, or inserted a Line chart. Choose the chart’s Scatter with only Markers subtype if you want unconnected points. A trendline is a separate fitted summary and does not need to connect the individual observations.
Can a scatter plot show dates on the X-axis?
Yes, if the cells contain valid Excel dates and the chart uses those values as X coordinates. Excel stores dates as serial numbers, so the points can be spaced by elapsed time. Format the horizontal axis labels as dates if they display as numbers or are difficult to read.
Related
- Excel Heatmap Table: How to Create and Read One
- Excel: Hide Column Headers Without Hiding Data
- Excel Heat Mapping: How to Create Useful Color Scales
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Keep Date Format in ExcelTo keep dates consistent in Excel, select the cells or column, open Format Cells, choose a date format,…
- Excel Columns: How Many Are There in a Full Worksheet?A standard modern Excel worksheet has 16,384 columns, labeled A through XFD. That limit applies to Excel for…
- Excel Cells Filled With Hashes? Causes, Fixes, and TipsIf an Excel cell displays ##### instead of a value, the most common reason is that its column…
- Excel Adjust Page Breaks for a Better Print LayoutTo adjust a print page break in Excel for Microsoft 365 on Windows, choose View > Page Break…
- Google Sheets Number Data Validation ExplainedYes. Google Sheets data validation can require a cell to contain a number that meets a rule, such…
- How to Make Every Other Row a Color in Excel (2 Ways)To color every other row in Excel, format your data as a table and choose a banded style,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.