Excel Scatter Plot Help: Create and Fix Your Chart

Charts & pivot tables · Updated November 21, 2026

To make an Excel scatter plot, put numeric X values in one column and matching numeric Y values beside them, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. A scatter plot places each paired value at its numeric position, making it useful for seeing how two measured variables relate.

What a scatter plot shows

A scatter plot, also called an XY chart, uses one numeric variable along the horizontal axis and another numeric variable along the vertical axis. Each row of data becomes a point: the value in the X column determines its left-to-right position, and the value in the Y column determines its height. The shape of the points can reveal a positive or negative association, a curved pattern, clusters, or unusual observations.

For example, suppose a small study records hours of sunlight and plant height. Sunlight values of 2, 4, 5, 7, and 8 hours paired with heights of 8, 11, 13, 17, and 19 centimetres make five plotted points. If the points generally rise from left to right, the measurements suggest that greater sunlight is associated with greater height in this sample. The chart alone does not prove that sunlight caused the difference; other factors, such as water or plant variety, could matter.

Unlike a column chart, a scatter plot does not treat every horizontal-axis value as a category with equal spacing. If X values are 1, 2, and 10, the point at 10 is placed much farther from 2 than 2 is from 1. That numeric spacing is central to what an XY chart communicates.

Prepare the data before charting

Excel needs the X and Y values to be paired correctly. Keep each observation on one row and use a separate column for each variable. A clear layout might have the heading Sunlight hours in A1, Plant height in B1, and the five observations in A2:B6. Select the headings too if you want Excel to use them as series names.

  • Use numeric values for both axes. Numbers stored as text may not plot as intended; dates and times can work when Excel recognizes them as dates or times.
  • Keep X and Y values for the same observation on the same row. Sorting just one column can break the pairings and produce a misleading chart.
  • Use one row for headings, and avoid blank rows or merged cells within the data block.
  • Decide how to handle missing measurements before charting. Do not enter a made-up zero unless zero is a genuine measurement; a zero can change the visual story substantially.

If the columns are separated by other data, select the X range first, then hold Ctrl on Windows while selecting the Y range. On Mac, use Command while selecting the second range. A contiguous two-column layout is usually easier to manage, especially when you add or edit series later.

Create a basic scatter plot in Excel

  1. Select the two data columns, including their headings if present.
  2. On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart.
  3. Choose the plain Scatter option, usually shown as markers without connecting lines. Excel inserts a chart on the worksheet.
  4. Click the chart title and type a descriptive title, such as Plant height by daily sunlight.
  5. Add axis titles if the units would otherwise be unclear. Choose Chart Design > Add Chart Element > Axis Titles, then edit the horizontal and vertical title boxes.

For the example above, the horizontal axis should be labelled Sunlight hours per day and the vertical axis Plant height (cm). Naming the variables and units makes the chart interpretable when it is copied into a report or viewed away from the source table. In Microsoft 365 for Mac, the Insert tab also offers scatter chart types; ribbon wording and arrangement can vary slightly by release, but the chart remains an XY scatter chart.

Format axes and markers for readability

To change an axis, right-click it and choose Format Axis. The Format Axis pane lets you adjust bounds, units, number formats, and other axis options. For example, if every plant height is between 8 and 19 cm, setting a sensible vertical-axis range can make differences easier to inspect. Be cautious with a truncated axis: it can make small differences look dramatic. If the chart is intended to compare magnitudes fairly, consider starting the axis at zero where that makes sense.

Axis bounds are not a substitute for checking the data. A very wide range can bunch the points together, while an overly narrow range can hide context or make an outlier disappear from view. If you set fixed minimum and maximum values, revisit them after the data changes; a new observation may fall outside the displayed range.

To change point appearance, click a marker in the series, right-click, and choose Format Data Series. The pane includes marker options such as shape, size, fill, and border. Use a marker large enough to see but not so large that overlapping observations become indistinguishable. If several points occupy the same or similar coordinates, some overlap is a property of the data, not a chart error. Transparency or a different marker style can make dense areas easier to notice.

Add another series, labels, or a legend

Use multiple series when you want to compare groups that share the same X and Y definitions, such as heights for two plant varieties at different sunlight levels. A convenient source layout is one X column followed by a Y column for each group. To add a series after making the chart, select it and choose Chart Design > Select Data > Add. In the Edit Series dialog, enter a series name and select the appropriate X values and Y values. Check that each range covers matching rows and excludes headings unless they are being used as the series name.

A legend helps readers distinguish multiple series, but it adds little value to a chart with only one series. You can manage it through Chart Design > Add Chart Element > Legend. Give series clear names in the source data rather than leaving generic labels such as Series 1. Different marker colours can help, but colour should not be the only distinction if the chart must remain clear in grayscale or for readers with colour-vision differences.

Point labels are useful when individual observations matter, but labelling every point in a large dataset can clutter the plot. Select the chart, then use Chart Design > Add Chart Element > Data Labels to add labels. For more control, open the data-label formatting options; in supported desktop Excel versions, Value From Cells can use a worksheet range such as product names as labels. Keep those labels in rows aligned with the plotted observations, and consider labelling only notable points if a full set is difficult to read.

Add a trendline and interpret it carefully

A trendline summarizes a broad pattern; it does not convert correlation into proof of cause. Select the plotted series, then choose Chart Design > Add Chart Element > Trendline and pick a suitable type. A linear trendline is a reasonable first look when the points follow an approximately straight pattern. A curved pattern may need a different model, but choosing a more complex trendline simply to make it fit the points can overstate what a small dataset supports.

You can use the Format Trendline pane to display the equation or R-squared value on the chart. The equation describes the fitted line, while R-squared indicates how much of the variation in the Y values is accounted for by that linear fit in the data being charted. Neither value establishes that the relationship is causal, nor does a high R-squared guarantee that the model is appropriate outside the observed range. Look at the points, sample size, measurement quality, and context as well.

Watch for outliers and clusters before summarizing the chart with one line. A single unusual point can influence a fitted line, and separate groups can have different patterns that disappear when combined. Investigate unexpected observations in the source data rather than deleting them automatically; they may be errors, or they may be meaningful results.

Common scatter plot problems and fixes

If Excel produces one point, an unexpected chart, or an empty plot, check the data selection and series definition. A common issue is that the X and Y columns were not both included, or that one range contains text. Use Chart Design > Select Data to inspect the series and confirm that the X values and Y values refer to the intended cells.

  • The horizontal axis shows 1, 2, 3 instead of your X values: inspect the series through Chart Design > Select Data and set its X values to the actual numeric X range. Excel may have interpreted the selection differently than intended.
  • Points are in the wrong order: verify that X and Y values are still paired row by row. Sorting one column by itself is a frequent cause.
  • Numbers are missing or plotted strangely: check for numbers stored as text, unexpected spaces, blank cells, or error values. Convert text that should be numeric and inspect formulas in the affected cells.
  • The chart skips gaps or draws an unexpected connection: in Chart Design > Select Data, use Hidden and Empty Cells to review how empty cells are displayed. The available choices can vary with chart type and Excel version.
  • Dates appear crowded or oddly spaced: confirm Excel recognizes the entries as dates. A scatter chart positions dates according to their underlying numeric date values, so gaps in time remain gaps rather than becoming evenly spaced categories.

When a chart looks wrong, it is often faster to inspect the selected ranges than to change formatting at random. Also check whether the workbook contains hidden rows or filtered data, because chart settings determine whether hidden data is included. If the source data is updated regularly, use a well-organized Excel table so newly added rows are easier to include in the chart; verify the chart range after extending the table.

Scatter plot versus line chart

Choose a scatter plot when the horizontal values are numeric measurements and their actual spacing matters, such as temperature, distance, time elapsed, or dosage. Choose a line chart when the horizontal axis represents ordered categories, such as months or product names, and equal spacing between categories is intended. A line chart can also show a time sequence, but its category axis may space entries evenly even when dates are irregular.

Both chart types can display markers and connecting lines, so appearance alone can be misleading. The key difference is how Excel treats the horizontal values: an XY chart uses numeric X coordinates, while a line chart generally uses a category axis. If you want points connected in an XY chart, choose a scatter subtype with straight lines or smooth lines. Connecting observations is appropriate when order and continuity are meaningful, but it can imply a path between measurements that should not be inferred for unrelated samples.

Frequently Asked Questions

How do I make a scatter plot with two columns in Excel?
Put X values in the first column and matching Y values in the second, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Add headings and axis titles so the variables and units are clear.

Why is Excel using the wrong values on the X-axis?
Open Chart Design > Select Data, select the series, and choose Edit. Check that Series X values point to the intended numeric cells and Series Y values point to their paired measurements. The ranges should have corresponding observations in the same row order.

Can I make a scatter plot with dates?
Yes, if Excel recognizes the dates as dates. A scatter chart treats dates as numeric positions, so irregular intervals between dates appear as irregular spacing. If the goal is to show evenly spaced named periods, a line chart may better match that intent.

How do I add a line of best fit?
Select the plotted series, then choose Chart Design > Add Chart Element > Trendline and select a suitable type, such as Linear. Review the point pattern and the assumptions before using the line to describe or predict a relationship.

Can a scatter plot show more than one group?
Yes. Add each group as a separate series, with its own X and Y ranges, using Chart Design > Select Data > Add. Use clear series names and distinguish the groups with readable markers or colours.

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.