How to Create a Scatter Plot in Excel Quickly and Easily

To create a scatter plot in Excel, first select your two columns of data (X and Y values). Then go to the Insert tab, click on Scatter Chart in the Charts group, and choose the desired scatter plot style to display your data points.

Syntax

Creating a scatter plot in Excel involves selecting data and using the Insert menu to add a chart. The main steps are:

• Select Data: Highlight two columns or rows representing X and Y values.
• Insert Scatter Chart: Go to the Insert tab, find the Scatter Chart icon in the Charts group.
• Choose Style: Pick a scatter plot style like simple dots or dots with lines.

text

1. Select your data range (e.g., A1:B10)
2. Click Insert tab
3. Click Scatter Chart icon
4. Choose a scatter plot style

Example

This example shows how to create a scatter plot from sample data of two columns: Height (cm) and Weight (kg).

Steps:

• Enter data in columns A and B.
• Select the data range A1:B6.
• Go to Insert > Scatter Chart.
• Choose the first scatter plot style (dots only).

csv

Height (cm),Weight (kg)
150,50
160,60
170,65
180,70
190,80

Output

Scatter plot showing points for Height vs Weight with dots representing each pair.

Common Pitfalls

Common mistakes when creating scatter plots in Excel include:

• Not selecting both X and Y data: Selecting only one column will not create a scatter plot.
• Including headers in selection: Sometimes headers get included and cause errors or wrong axis labels.
• Using non-numeric data: Scatter plots require numeric values for both axes.
• Choosing wrong chart type: Selecting a line chart instead of scatter plot changes the data visualization.

Always double-check your data selection and chart type.

text

Wrong way:
Select only one column (e.g., A1:A6) and insert scatter plot → No meaningful chart.

Right way:
Select both columns (A1:B6) including numeric data only, then insert scatter plot.

Quick Reference

Step	Action
1	Select two columns of numeric data (X and Y)
2	Go to Insert tab in Excel ribbon
3	Click on Scatter Chart icon in Charts group
4	Choose scatter plot style (dots, dots with lines)
5	Adjust chart title and axis labels if needed

Key Takeaways

Select both X and Y numeric data columns before inserting a scatter plot.

Use the Insert tab and choose Scatter Chart to create the plot.

Avoid including headers or non-numeric data in your selection.

Pick the correct scatter plot style to best visualize your data.

Check your chart labels and formatting after creating the plot.