The basic steps to make a scatter plot

A scatter plot in Excel shows the relationship between two sets of numbers by plotting each pair as a dot on a grid. To create one, you need two columns of data, select both columns, then use Excel's chart tools to insert a scatter chart type. The whole process takes about two minutes once your data is ready.

Start by arranging your data in two adjacent columns. Put one set of numbers in column A and the other in column B. For example, if you're plotting hours studied against test scores, put the hours in column A and the scores in column B. Include a header row with labels like "Hours Studied" and "Test Score" — Excel will use these to label your axes.

Select both columns of data by clicking on the first cell and dragging to the last row that contains data. Make sure you include the header row. Then go to the Insert tab at the top of the screen, click on the Charts group, and look for the scatter chart icon (it looks like dots scattered across a grid). Click it and choose the first option, "Scatter" or "Scatter (Points Only)".

Key Takeaways

  • Arrange your two data sets in adjacent columns with headers, then select both columns before inserting a chart.
  • Use the Insert tab, find the Charts group, and select the Scatter chart type to create your plot.
  • Excel automatically places one data set on the horizontal axis and one on the vertical axis based on your selection order.
  • You can change axis labels, add a title, and adjust the plot area by right-clicking on different parts of the finished chart.
  • If your data includes text or blank cells mixed in with numbers, Excel may misread which columns to plot — clean your data first by removing extra rows or columns.

Preparing your data before you chart

Excel works best with clean data. This means no blank rows in the middle of your numbers, no text mixed into number columns, and no extra spaces before or after values. If you have data spread across multiple sheets or with gaps, copy the two columns you want to plot into a single clean section first.

Check that both columns have the same number of rows. If one column has 50 data points and the other has 45, Excel will only plot the pairs where both values exist. Delete or add rows as needed so they match. Also make sure your header row is actually a header — if the first row contains numbers instead of labels, Excel may try to plot it as data.

Understanding which axis gets which data

In a scatter plot, the first column you select becomes the horizontal axis (called the X-axis) and the second column becomes the vertical axis (called the Y-axis). This matters because the axes tell the story of your data. If you're showing how study hours affect test scores, you want hours on the X-axis and scores on the Y-axis, so put hours in column A and scores in column B before selecting.

If you select the columns in the wrong order, you can fix it after the chart is made. Right-click on the chart, choose "Edit Data" or "Select Data", and you'll see options to swap which data series goes on which axis. This is easier than starting over.

Customizing titles, labels, and the plot area

Once your scatter plot appears, you can add a title and change the axis labels. Click on the chart to select it, then look for the Chart Elements button (a plus sign) on the right side. Check the box next to "Chart Title" to add one, then click on the title text to edit it. Do the same for "Axis Titles" to label your X and Y axes with something more descriptive than "Series 1".

To change the range of numbers shown on an axis, right-click on the axis itself (the numbers along the left or bottom edge) and choose "Format Axis". You can set the minimum and maximum values, which is useful if you want to zoom in on a specific range or start your axis at zero instead of at the lowest data point.

Adding a trend line to show patterns

A trend line is a straight or curved line that runs through your scattered points to show the overall direction of the relationship. To add one, right-click on any data point in the scatter plot and choose "Add Trendline". Excel will draw a line that best fits your data. This is helpful when you want to see whether two things tend to move together or apart.

You can choose between a linear trend line (straight) or other types like exponential or logarithmic. For most everyday data, linear is the right choice. You can also check the box to display the equation of the line and the R-squared value, which tells you how well the line fits the actual data — closer to 1.0 means a better fit.

Fixing common problems with scatter plots

If your scatter plot shows only one or two points instead of many, Excel probably read your data as text instead of numbers. Check that your columns contain only numbers with no letters or symbols mixed in. If you have dollar amounts like "$50" or percentages like "50%", remove the symbols and keep just the numbers.

If the chart looks empty or shows an error, make sure you selected both columns before inserting the chart. Also check that your data doesn't have blank rows in the middle — Excel stops reading when it hits an empty cell. If you need to include data with gaps, copy just the filled cells into a new location and chart from there.

If your axes show the wrong range or your points are bunched in one corner, right-click on the axis and adjust the minimum and maximum values. Sometimes Excel auto-scales in a way that makes your data hard to read, and manually setting the axis range fixes this.

When to use a scatter plot instead of other chart types

A scatter plot is the right choice when you want to show how two continuous numbers relate to each other — like age and income, temperature and ice cream sales, or study time and grades. It's different from a bar chart, which compares categories, or a line chart, which shows how one number changes over time.

Scatter plots are especially useful when you have many data points and want to spot patterns, clusters, or outliers. If you have only a few points, the pattern may not be clear. If you're comparing more than two variables, you'll need a different approach, like a bubble chart (which adds a third variable as the size of each dot) or multiple scatter plots side by side.

Frequently Asked Questions

Can I create a scatter plot with more than two columns of data?

A standard scatter plot shows only two variables. If you want to add a third variable, use a bubble chart instead, where the size of each dot represents the third number. To make a bubble chart, select three columns and choose the bubble chart type from the Insert Charts menu.

What if my data has negative numbers?

Scatter plots handle negative numbers just fine. Excel will automatically adjust your axes to include negative values. Your plot will show points in all four quadrants if needed — for example, if you're plotting profit (which can be negative) against time.

How do I move or resize my scatter plot after I create it?

Click on the chart border to select it, then drag it to a new location on your sheet. To resize it, click and drag one of the small squares at the corners or edges. You can also cut and paste the chart to a different sheet if you want to move it there.

Can I change the color or style of the dots in my scatter plot?

Right-click on any dot in the plot and choose "Format Data Series". You'll see options to change the color, size, and transparency of the dots. You can make all dots the same color or use different colors for different groups by selecting individual points.

What does the R-squared value on a trend line mean?

The R-squared value tells you how well your trend line fits the data, on a scale from 0 to 1. A value close to 1 means the line fits very well and the two variables are strongly related. A value close to 0 means the line doesn't fit well and the relationship is weak or doesn't exist.