Creating a scatter plot starts with arranging your data in two columns
A scatter plot in Excel shows the relationship between two sets of numbers by plotting each pair as a dot on a graph. To build one, you need your data in two adjacent columns — one for the horizontal axis (called the X-axis) and one for the vertical axis (called the Y-axis). Each row represents one data point.
For example, if you wanted to see whether house size relates to house price, you would put square footage in column A and price in column B, with one property per row. Excel reads across each row and plots a single dot at the intersection of those two values.
The data does not need to be sorted or in any particular order. Excel will plot whatever you give it. You can have as few as two data points or hundreds — the scatter plot will show them all.
Key Takeaways
- Arrange your two data sets in adjacent columns, with one value per row, before you select any cells.
- Select both columns including headers, then use the Insert menu to choose the XY (Scatter) chart type.
- Excel offers several scatter plot styles: dots only, dots with lines, or lines only — choose based on whether you want to show individual points or a trend.
- Add axis titles and a chart title so anyone reading the plot understands what each axis represents and what the plot shows.
- You can move the chart anywhere on your sheet and resize it by dragging the edges.
Select your data before opening the chart menu
Click on the first cell of your first column (including the header if you have one) and drag to the last cell of your second column that contains data. Both columns must be selected together. If your data is in columns A and B and goes down to row 50, select from A1 to B50.
You can also click the first cell, hold Shift, and click the last cell to select the range without dragging. Excel will highlight the selected area in blue.
If your columns are not adjacent — for example, if data is in column A and column C with column B empty between them — you can still select both by holding Ctrl while clicking each column. This is less common but works if your spreadsheet layout requires it.
Insert the scatter chart from the Insert menu
With your data selected, click the Insert tab at the top of the Excel window. Look for a button labeled Charts or a chart icon. Click it to open the chart menu.
You will see a list of chart types. Find and click XY (Scatter). Excel will show you several scatter plot styles: the first shows only dots, others show dots connected by lines, and some show lines only without dots. Click the style you want.
Excel will place the chart on your spreadsheet when ready. It may cover some of your data — that is normal. You can move it by clicking and dragging the chart itself to a blank area.
Choose the right scatter plot style for your data
The dots only style (the first option) works best when you want to see individual data points and whether they cluster or spread out. Use this when you are exploring whether two things relate to each other at all.
The dots with lines style connects each point in the order they appear in your spreadsheet. This is useful if your data follows a sequence — for example, temperature and humidity measured at different times of day. The line shows the path the data took.
The lines only style removes the dots and shows just the connecting line. This is less common for scatter plots because it can hide individual values, but it works when you have many points and want to emphasize the overall trend rather than each separate measurement.
Add titles so the plot is clear to anyone reading it
Click on the chart to select it (you will see a border around it). At the top of the Excel window, a new tab labeled Chart Design will appear. Click it.
Look for a button labeled Add Chart Element or Chart Title. Click it and select Chart Title. A text box will appear at the top of the chart. Type a title that describes what the plot shows — for example, "House Size vs. Price" or "Temperature and Humidity by Hour".
To add axis titles, click Add Chart Element again and select Axis Titles. Choose Primary Horizontal to label the X-axis and Primary Vertical to label the Y-axis. Type what each axis measures — for example, "Square Feet" for the horizontal axis and "Price ($)" for the vertical axis.
Move and resize the chart to fit your sheet
Click anywhere on the chart to select it. A border with small squares at the corners and edges will appear. You can drag the chart by its center to move it to a different location on your sheet, or drag the small squares to resize it.
Dragging a corner square resizes the chart while keeping its proportions. Dragging a side or top/bottom square stretches it in one direction only. Make the chart large enough that the numbers on the axes are readable.
If you want to delete the chart, select it and press Delete. The chart disappears but your data remains unchanged.
Edit the data or appearance after the chart is built
If you change a number in one of your data columns, the scatter plot updates automatically. You do not need to rebuild it.
To change colors, fonts, or other appearance details, right-click on the chart and select Format Chart Area. A panel will open with options for background color, borders, and text formatting. You can also right-click on the dots themselves to change their color or size.
To change which data the chart uses, right-click the chart and select Select Data. This opens a dialog where you can add or remove columns, or swap which axis each column represents.
Frequently Asked Questions
Can I make a scatter plot with more than two columns of data?
A single scatter plot shows only two variables at once. If you want to compare three or more things, you can create multiple scatter plots on the same sheet, or use a different chart type like a bubble chart (which adds a third variable as the size of each dot). For most situations, separate scatter plots are clearer.
What if my data has text in it instead of numbers?
Scatter plots require numbers on both axes. If a column contains text, Excel will skip it or show an error. Make sure both columns contain only numbers (or dates, which Excel treats as numbers). If you need to show categories, use a different chart type like a bar or column chart.
How do I change which column is the X-axis and which is the Y-axis?
Right-click the chart and select Select Data. In the dialog that opens, you will see your data series listed. Click it and then click Edit. You can swap the X and Y values by changing which column is assigned to each axis.
Can I add a trend line to show the overall pattern?
Yes. Click the chart to select it, then right-click on one of the dots. Select Add Trendline. Excel will draw a line through your data showing the general direction — upward, downward, or flat. This helps you see the relationship even if individual points scatter widely.
What if I want to print just the chart without the spreadsheet data?
Click the chart to select it, then go to File and click Print. Excel will print only the selected chart. If the chart is not selected, it will print the entire sheet.