Scatter Plot Maker in Excel: Create and Customize Charts

Charts & pivot tables · Updated November 21, 2026

To make a scatter plot in Microsoft Excel for Microsoft 365 on Windows, put your X values in one column and matching Y values in the next, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Excel creates a chart in which each row becomes a point, letting you see how two numeric variables relate.

What an Excel scatter plot shows

A scatter plot, also called an XY chart, places one numeric measurement on the horizontal axis and another on the vertical axis. Each observation is represented by a dot at the intersection of its two values. The pattern can reveal whether the variables tend to rise together, move in opposite directions, form a curve, or show no obvious relationship.

For example, a small business might plot advertising spend on the X axis and weekly sales on the Y axis. If each row contains one week’s figures, a cluster of dots that generally rises from left to right suggests that higher spending coincided with higher sales in those observations. It does not, by itself, prove that advertising caused the increase; other factors may be involved.

Scatter plots are useful when both measurements are numeric and the relationship between them matters. They also help expose outliers, groups, and unusual patterns that a table can hide. Unlike a line chart, a scatter plot treats the horizontal values as numbers with meaningful distances between them, rather than as a sequence of equally spaced categories.

Prepare the data before inserting the chart

Arrange the source data so that each row describes one observation and the two variables sit in separate columns. Put the X variable in the left column and the Y variable in the right column, with descriptive headings in the first row. For instance, column A could be Temperature and column B could be Ice Cream Sales. Keep the values paired: the temperature and sales figure on the same row must refer to the same day.

  • Use numeric values for both axes. Text that looks like a number may not be treated as a number if it contains an unexpected space or character.
  • Keep headings outside the measurement rows, and include them in the selection if you want Excel to use them as series or axis information.
  • Check for blank rows, errors, and mismatched records. A missing X value means Excel cannot place that observation in the usual way.
  • Use consistent units. Mixing inches and centimetres, for example, can make the apparent relationship misleading.
  • Dates are stored as numbers in Excel and can be plotted on an XY axis. Apply a date number format if the axis should display dates rather than serial values.

Sorting the data by X value is not necessary for a basic scatter plot: Excel positions each point according to its values. Sorting can make a connected scatter chart easier to follow, but it is not a substitute for choosing the appropriate chart type.

Create a basic scatter plot in Excel

  1. Click a cell in the data range, or select the two columns of values and their headings. If Excel selects an unintended range, you can correct the series after inserting the chart.
  2. Open the Insert tab. In the Charts group, choose Insert Scatter (X, Y) or Bubble Chart.
  3. Under Scatter, choose the first option, typically Scatter or Scatter with Only Markers. This displays individual points without connecting lines.
  4. Click the chart title and type a descriptive title. Add axis titles if readers need to know what each measure represents and which units it uses.

For the most predictable result, select the X and Y columns together. Excel usually interprets the first selected numeric column as X values and the next as Y values. If the chart has the axes reversed or includes an unwanted series, select the chart and use Chart Design > Select Data to inspect or edit its data series.

Choose the right scatter chart subtype

The basic scatter chart shows markers only, which is generally the clearest choice when each point is an independent observation. Excel also offers scatter charts with straight lines, smooth lines, or lines and markers. Lines can help when points represent a meaningful ordered sequence, such as measurements taken over time, but they can imply continuity between unrelated observations. A smooth curve is a visual interpolation, not evidence that the underlying relationship follows that exact curve.

Use a bubble chart when a third numeric variable should control the size of each point. For example, X could be product price, Y could be units sold, and bubble size could represent market share. Bubble size adds another visual measure, but overlapping bubbles can be hard to compare, so it is most useful when the number of observations is manageable.

When creating several series, each series can have its own X and Y ranges. Select the chart, choose Chart Design > Select Data > Add, then specify a series name, the X values, and the Y values in the dialog. This is useful for comparing groups, such as results from different stores, while keeping the same axes. Make sure the X and Y ranges in each series contain the same number of corresponding observations.

Format axes, markers, and labels

Make the chart readable before adding decoration. Click the chart and use the Chart Elements button, shown as a plus sign beside the chart, to add or remove elements such as axis titles, gridlines, and a legend. You can also use Chart Design > Add Chart Element. A useful axis title names the variable and its unit, such as Distance (km), rather than merely repeating X or Y.

To adjust an axis, right-click it and choose Format Axis. The pane lets you set bounds, major units, number formats, and other scale options. Setting minimum and maximum bounds can make comparisons easier, but an axis that begins far above zero may exaggerate visual differences. For a logarithmic scale, all plotted values on that axis must be positive; zeros and negative values cannot be displayed on a logarithmic axis.

To change the appearance of points, click a marker and open Format Data Series. Adjust marker size, fill, or border so dots remain visible without obscuring one another. If many points overlap, try smaller markers, transparency, or separate series. A legend is helpful when colors distinguish meaningful groups, but it is unnecessary for a single series.

Data labels are most helpful when a reader needs to identify individual observations. Select the chart, choose Chart Design > Add Chart Element > Data Labels, and then use More Data Label Options to choose what appears. In supported Microsoft 365 desktop versions, Value From Cells can use a range of names or IDs as labels. Labeling every point in a large dataset usually creates clutter; consider labeling only important points or adding a small accompanying table.

Add a trendline without overstating the result

A trendline summarizes a general pattern in the plotted points. Select the chart and use Chart Design > Add Chart Element > Trendline, or use the Chart Elements plus button. Excel offers choices such as linear, exponential, logarithmic, polynomial, and moving average, although not every type suits every dataset. A linear trendline is a reasonable starting point when the points appear to follow an approximately straight pattern.

For a linear trendline, Excel can display its equation and the R-squared value on the chart through the trendline formatting options. R-squared describes how closely the fitted line accounts for variation in the plotted Y values under that model; it is not a measure of causation, and a high value does not guarantee a useful prediction outside the observed data. Check the units, sample size, outliers, and whether the chosen model makes sense before interpreting the line. A trendline should explain a pattern, not make a weak or biased dataset appear conclusive.

Common problems and how to fix them

If Excel plots the wrong values or leaves the chart blank, first check whether the source cells are truly numeric. Text-formatted numbers, errors, and empty cells can interfere with plotting. Select the chart and open Chart Design > Select Data to verify the series ranges. In the Edit Series dialog, confirm that the intended X range is in Series X values and the intended Y range is in Series Y values.

  • The chart looks like a line chart: Check that you chose a Scatter subtype, not a Line chart. A line chart spaces categories evenly; an XY chart uses numeric X positions.
  • Points appear in the wrong order or at unexpected positions: Inspect the X and Y series references and check for text values, dates, or unintended rows in the selected range.
  • The X axis shows 1, 2, 3 instead of the measurements: Excel may have treated the data as a single Y series and supplied default X positions. Edit the series and assign the actual X range.
  • The plot is crowded: Reduce marker size, use transparency, split groups into series, or chart a smaller relevant sample. More labels are rarely the best fix.
  • A point is missing: Look for a blank or error in either value of that row. Review how the chart handles hidden and empty cells through Chart Design > Select Data > Hidden and Empty Cells.

Large differences in scale can also make a genuine relationship difficult to see. Check units and ranges before changing axis bounds, and avoid changing them solely to make the pattern appear stronger. If the X values are labels such as departments or product names rather than quantities, a scatter plot may not answer the question; a bar chart or another category-based chart is often clearer.

Excel desktop, Mac, and web differences

The steps above are for Excel for Microsoft 365 on Windows. Excel for Mac also supports XY scatter charts, and the core workflow is similar: select the data, use the Insert tab to choose a scatter chart, and adjust the series and formatting through the chart tabs. Ribbon arrangement and some dialog details can vary by Mac release, so look for the Insert Scatter chart control if its position differs.

Excel for the web can create and edit charts, including scatter charts, but some chart-formatting options may be more limited or arranged differently from desktop Excel. If a particular setting, such as a detailed series adjustment or advanced axis option, is unavailable in the browser, open the workbook in the desktop app. Excel desktop and web can also render a chart differently in some cases, so check the finished chart in the version where it will be presented.

Scatter plots compared with other Excel charts

A line chart is often better for a time series when the horizontal axis represents dates or categories in a regular sequence and the emphasis is on change over time. A scatter plot is better when the spacing between numeric X values matters or when the goal is to study the relationship between two measured quantities. A column or bar chart is usually clearer for comparing a small set of named categories.

There is no separate scatter-plot maker required for ordinary Excel work: the chart tools built into the spreadsheet are enough for most two-variable analysis. Dedicated statistical software may be useful for specialized analysis, reproducible modeling, or very large datasets, but it is not necessary just to plot paired values and inspect their pattern. Whatever tool you use, the chart is only as reliable as the data definitions and collection process behind it.

Frequently Asked Questions

Can Excel make a scatter plot with two nonadjacent columns?
Yes. Insert a scatter chart, select it, and choose Chart Design > Select Data > Add. Set the X values and Y values to the appropriate ranges. This is more reliable than expecting Excel to interpret a nonadjacent selection automatically.

How do I change which column is on the X axis?
Select the chart and open Chart Design > Select Data. Edit the series and replace its Series X values range with the intended numeric column. Confirm that the Series Y values range contains the matching observations.

Can a scatter plot use dates on the X axis?
Yes. Excel stores valid dates as serial numbers, so they can be plotted as X values. Format the axis to display dates if needed, and confirm that the source cells contain real Excel dates rather than text that only looks like a date.

What is the difference between a scatter plot and a line chart?
A scatter plot positions points according to numeric X and Y values. A line chart treats its horizontal axis as categories or a sequence, typically spacing categories evenly. Use scatter when numeric horizontal distances matter; use a line chart when the ordered sequence is the main point.

Can Excel add names beside scatter plot points?
Yes. Add data labels, open the label options, and use Value From Cells to select a range containing names or IDs, where that option is available in your Excel version. If there are many points, label only the observations readers need to identify.

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.