Creating a scatter plot in Excel takes four steps: enter your data in two columns, select both columns, choose the XY (Scatter) chart type, and place it on your sheet

A scatter plot shows the relationship between two sets of numbers by plotting each pair as a point on a grid. If you have data in Excel — say, monthly sales figures paired with advertising spend, or test scores paired with study hours — a scatter plot lets you see whether one tends to rise or fall with the other. Excel builds the chart automatically once you select your data and pick the right chart type.

You do not need to rearrange your data or learn formulas. If your numbers are already in two columns, you are ready to start.

Key Takeaways

  • Scatter plots work best when you have two columns of related numbers, with one value in each row paired with another.
  • Excel's XY (Scatter) chart type is the correct choice; other chart types will not show the relationship the way you need.
  • You select both columns of data at once, including headers if you have them, then insert the chart from the Insert menu.
  • After the chart appears, you can move it, resize it, and add titles or labels to make it clearer what the plot shows.

Preparing your data in the right format

Scatter plots need two columns of numbers. Put your first set of values in one column (for example, column A) and your second set in the next column (column B). Each row should have one pair: if row 2 has the value 10 in column A, row 2 should have its matching value in column B.

If your data has headers — like "Hours Studied" in A1 and "Test Score" in B1 — leave them in place. Excel recognizes headers and will not plot them as data points. Your actual numbers start in row 2.

Make sure both columns have the same number of rows. If column A has 50 data points and column B has only 40, Excel will only plot the first 40 pairs. Delete or add rows until they match.

Selecting your data and opening the chart menu

Click on the first cell of your first column (A1 if you have a header, or A2 if you do not). Hold down the mouse button and drag to the last cell of your second column that contains data. If your data runs from A1 to B50, drag from A1 to B50. You should see both columns highlighted in blue.

Alternatively, click on A1, then hold Shift and click on B50. This selects the entire range without dragging.

Once your data is selected, go to the Insert menu at the top of Excel. Look for the Charts section. You will see several chart type icons. Click on the one labeled XY (Scatter). A small menu will appear showing different scatter plot styles.

Choosing the scatter plot style that fits your data

Excel offers several scatter plot variations. The most common is Scatter with only Markers — this shows each data point as a dot with no lines connecting them. Choose this if you want to see the overall pattern without visual clutter.

If you want to see a trend, pick Scatter with Straight Lines and Markers. This connects the dots in order, which can help you spot whether the relationship is steady or jumpy. Use this when the order of your data matters — for example, if you are tracking a value over time.

Scatter with Smooth Lines and Markers draws a curved line through the points instead of straight segments. This is less common and works best when you know the relationship between your two variables should be smooth.

For most purposes, start with Scatter with only Markers. You can change the style later if you need to.

Placing and resizing your chart

After you click your chosen scatter plot style, Excel creates the chart and places it on your sheet. The chart appears as a box with your data plotted inside. It may overlap your data or sit in an awkward spot.

To move the chart, click on it once to select it (you will see a border around it), then click and drag it to a new location. To resize it, click on the chart, then grab one of the small squares at the corners or edges and drag outward to make it larger or inward to make it smaller.

If the chart is too small to read clearly, make it wider and taller. A scatter plot with room to breathe is easier to interpret than one crammed into a tiny box.

Adding titles and labels to clarify what the plot shows

Right-click on your chart and select Edit Chart (or double-click the chart). A toolbar will appear with chart editing options. Look for the option to add a Chart Title — click it and type a name that describes what you are showing, like "Sales vs. Advertising Spend" or "Study Hours vs. Test Score".

You can also add axis titles. Right-click on the number labels along the bottom of the chart (the horizontal axis) and choose Add Axis Title. Type the name of what those numbers represent — for example, "Hours Studied". Do the same for the vertical axis on the left side.

These labels help anyone reading your chart understand what each axis measures. Without them, a scatter plot is just dots on a grid.

Interpreting what your scatter plot shows

Once your chart is complete, look at the pattern of dots. If they trend upward from left to right, the two variables have a positive relationship — as one increases, the other tends to increase too. If they trend downward, they have a negative relationship — as one increases, the other tends to decrease.

If the dots are scattered randomly with no clear pattern, the two variables may not be related. If the dots form a tight line or cluster, the relationship is strong. If they are spread out, the relationship is weaker.

Remember that a scatter plot shows correlation — whether two things move together — not causation. A scatter plot of ice cream sales versus drowning deaths might show a positive relationship, but ice cream does not cause drowning. Both rise in summer.

Frequently Asked Questions

Can I create a scatter plot if my data is not in two adjacent columns?

Yes. Select your first column, then hold Ctrl (or Cmd on Mac) and click on your second column while still holding Ctrl. This selects two non-adjacent columns. Then insert the chart as normal. Excel will use the first column as your horizontal axis and the second as your vertical axis.

What if I want to plot more than two variables at once?

A standard scatter plot shows only two variables. If you have three or more, you can create multiple scatter plots — one for each pair — or use a different chart type like a bubble chart, which adds a third dimension as the size of each dot. For most purposes, separate scatter plots are clearer.

How do I change the color or size of the dots after the chart is made?

Double-click the chart to edit it, then right-click on one of the dots. Select Format Data Series. A panel will open where you can change the color, size, and transparency of the markers. You can make all dots the same color or assign different colors to different data series if you added multiple.

Can I add a trend line to show the overall direction?

Yes. Double-click the chart to edit it, then right-click on any data point. Choose Add Trendline. Excel will draw a straight or curved line through your data showing the general trend. This helps readers see the relationship at a glance, even if individual points are scattered.

What should I do if my scatter plot looks empty or shows only one or two dots?

Check that both columns have the same number of rows and that all cells contain numbers, not text. If one column has text mixed in, Excel may skip those rows. Also verify that you selected both columns before inserting the chart. If the chart still looks wrong, delete it and start over with a fresh selection.