Scatter Plot in Excel With Two Variables

How-to basics · Updated November 21, 2026

To make a scatter plot in Excel with two variables, put each variable in its own numeric column, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Excel plots the first column on the horizontal X-axis and the second on the vertical Y-axis, with one dot for each paired row.

What a two-variable scatter plot shows

A scatter plot, also called an XY chart, displays the relationship between two numerical variables. Each observation becomes a point positioned by its X value and its Y value. For example, if a class records study hours and exam scores, one student’s values might be 3 hours and 70 points; Excel places that observation at X = 3 and Y = 70.

This makes a scatter plot useful when you want to see whether two quantities appear to move together, whether the pattern is curved, or whether a few observations sit far from the rest. It is different from a line chart: a scatter plot uses numerical horizontal positions, while a line chart commonly spaces categories evenly along the horizontal axis.

With two variables, the chart usually contains one data series made up of many points. The two columns are the X and Y measurements for that series; they are not automatically two separate lines or groups. If you want to compare groups, such as scores for two classes, you can add a separate series for each group.

Arrange the data before inserting the chart

Set up the worksheet so every row contains one matched pair of observations. Put the variable that should explain or organize the horizontal position in the first column, and the other variable in the second. Use clear headers in the top row, and avoid blank rows within the data.

  • Column A: Study hours, with values such as 1, 2, 3, 4, and 5.
  • Column B: Exam score, with corresponding values such as 58, 64, 70, 78, and 85.

Here, the first student’s study hours must stay on the same row as that student’s score. Sorting only one column would break the pairs and make the chart misleading. If you need to sort, select the whole data range and sort the rows together.

Make sure the observations are numeric values, not numbers stored as text. Dates and times can also be plotted as numeric values, though their axes may need formatting. If some rows have a missing X or Y value, decide whether to exclude those incomplete pairs or fill them using a justified method; a dot cannot represent a complete pair when one coordinate is absent.

Create the scatter plot in Excel for Windows

  1. Enter the two variables in adjacent columns, with a header above each column.
  2. Select the headers and all paired values. For the example, select A1:B6.
  3. Open the Insert tab.
  4. Choose Insert Scatter (X, Y) or Bubble Chart in the Charts group, then select the basic Scatter option, usually shown with markers and no connecting lines.
  5. Check that the plotted points and axis labels make sense. Add a chart title and axis titles so the variables and units are clear.

Excel may use the column headers as a series name, but it does not necessarily display the variable names as axis titles. Add those separately: select the chart, then choose Chart Design > Add Chart Element > Axis Titles and select the horizontal or vertical title. For a chart title, use Chart Design > Add Chart Element > Chart Title. You can also select the chart and use the Chart Elements button beside it in desktop Excel.

If the two columns are not next to each other, insert a chart and set its series ranges manually, or copy the columns beside each other temporarily. To edit the ranges, right-click the chart and choose Select Data. Select the series and choose Edit; enter the X values and Y values from their respective worksheet ranges. Keep the two ranges the same length and exclude header cells from the value ranges.

Check which variable is on each axis

A scatter chart’s axis assignment matters. The horizontal axis should contain the independent, input, or explanatory variable when that is the relationship you want to examine. The vertical axis commonly holds the outcome or response. These labels describe a useful convention, not proof that one variable causes the other.

Excel usually assigns the leftmost selected numeric column as X and the next as Y. If the chart appears reversed, use Chart Design > Select Data, choose the series, click Edit, and confirm the Series X values and Series Y values ranges. The exact dialog wording can vary slightly by Excel build, but the series editor provides separate X and Y fields.

A quick check is to click a point and inspect its coordinates in the formula bar or select the series and examine its range settings. Another practical check is to consider the scale: if the horizontal axis shows exam scores when you expected study hours, the columns may be assigned in reverse. Swapping axes changes the chart’s interpretation, even though the same pairs remain plotted.

Choose markers, lines, and useful formatting

For most two-variable data, the markers-only scatter subtype is the clearest starting point. Each dot then represents an observation without implying that the values form a continuous path. Scatter subtypes with straight lines or smooth lines connect points in their worksheet order; use them only when that sequence is meaningful, such as measurements collected over time and sorted chronologically.

Formatting should make the relationship easier to read, not decorate the chart. Include units in axis titles, such as Study time (hours) and Score (points). If values cover a wide range, adjust the axis bounds or number format so important differences are visible. To format an axis, right-click it and choose Format Axis. Be cautious about setting a minimum that cuts off meaningful values, since that can exaggerate visual differences.

To add a fitted line, select the chart and use Chart Design > Add Chart Element > Trendline, then choose an appropriate option such as Linear. A linear trendline summarizes a roughly straight pattern; it does not establish causation, guarantee accurate predictions, or prove that the relationship is statistically significant. If the points bend, a linear line may be a poor summary.

When points overlap, several observations may occupy the same or very similar coordinates. Smaller markers or some transparency can make dense areas easier to see. If the chart has many thousands of points, consider whether a different view, such as a density-oriented visualization or a carefully sampled subset, would communicate the pattern more clearly.

Interpret the pattern without overclaiming

Look first at the overall direction. A cloud that rises from left to right suggests a positive association: larger X values tend to occur alongside larger Y values. A downward pattern suggests a negative association. A shapeless cloud may indicate little visible relationship, though a weak or nonlinear relationship can be difficult to recognize by eye.

Next, look for curvature, clusters, and unusual points. A curved shape can mean that a straight-line summary misses the pattern. Separate clusters may reflect different populations, locations, or measurement conditions. An outlier deserves checking because it could be a genuine unusual observation, a data-entry error, or a case with a different context. Do not remove it merely because it changes the chart’s appearance.

In the study-hours example, the five pairs rise from 1 hour and 58 points to 5 hours and 85 points. That small set appears to move upward, but it is not enough to conclude that additional study caused higher scores. Prior knowledge, course difficulty, and other factors could also matter. A chart is a way to explore the data; sound interpretation depends on how the observations were collected and what else may influence them.

Common problems and how to fix them

  • Excel creates an unexpected chart: Confirm that you chose a Scatter chart, not a line chart. The Scatter option is under Insert > Insert Scatter (X, Y) or Bubble Chart.
  • Only one point or an empty chart appears: Check that the selected ranges contain numeric values and that the X and Y ranges have matching numbers of observations. Look for numbers stored as text or empty cells.
  • The axes are reversed: Edit the series through Chart Design > Select Data and assign the intended ranges to the X and Y fields.
  • The first row appears as a point: Edit the series ranges and exclude the header row from the numeric values. Set the series name to the header if needed.
  • Points appear in odd positions: Check for mismatched row pairs, hidden spaces or text in numeric cells, and accidental sorting of only one column.
  • The chart looks flat: Review the axis bounds and units. A very wide scale or a few extreme observations can compress the rest of the points visually.

When troubleshooting, edit the chart’s series rather than repeatedly inserting new charts. A scatter plot stores the X and Y ranges separately, so the Select Data dialog is often the quickest place to diagnose an assignment problem.

Scatter plot versus line chart

Use a scatter plot when both variables are quantitative and the horizontal values represent actual numerical distances. For instance, the distance between X values 1 and 2 is the same as between 4 and 5. This is important when the spacing itself carries meaning.

Use a line chart when the horizontal axis represents ordered categories or a sequence where category spacing is intended to be uniform, such as monthly sales by month. A line chart can be appropriate for time-series data, especially when you want to emphasize continuity. But if your dates are irregular and the actual elapsed time matters, an XY scatter chart can show the uneven intervals more faithfully.

Neither chart type is universally better. Choose based on what the X values mean and whether Excel should treat their spacing as numeric distance or as equally spaced categories.

Frequently Asked Questions

Can I make a scatter plot with two columns in Excel?
Yes. Put paired numeric values in two columns, select the data, and choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. The first column normally supplies X and the second supplies Y.

How do I make an XY scatter plot with different X and Y ranges?
Insert a scatter chart, right-click it, and choose Select Data. Edit the series and assign the desired cell range to Series X values and the other range to Series Y values. The two ranges must contain the same number of paired observations.

How do I add a trendline to a scatter plot?
Select the chart and choose Chart Design > Add Chart Element > Trendline, then select a suitable type, such as Linear. Treat the line as a summary of the plotted pattern, not as evidence of cause and effect.

Can I create this chart in Excel for Mac?
Yes. Arrange the paired columns, select them, and use the Insert tab to choose an XY scatter chart. Ribbon labels and dialog placement can differ slightly from Windows; the chart’s data-series settings still let you assign X and Y ranges.

Why does my scatter plot show one dot per row?
That is expected: each complete row supplies one X-Y pair and becomes one point. If you intended two groups, create a separate series for each group rather than treating the two variables as separate plotted series.

Related

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.