Scatter Plot in Excel

Use a scatter plot (XY chart) to show scientific XY data. Scatter plots are often used to find out if there's a relationship between variables X and Y.

Only Markers

To find out if there is a relationship between X (a person's salary) and Y (his/her car price), execute the following steps.

1. Select the range A1:B10.

2. On the Insert tab, in the Charts group, click the Scatter symbol.

3. Click Scatter.

Result:

Note: we added a trendline to clearly see the relationship between these two variables.

Straight Lines

To create a scatter plot with straight lines, execute the following steps.

1. Select the range A1:D22.

2. On the Insert tab, in the Charts group, click the Scatter symbol.

3. Click Scatter with Straight Lines.

Note: also see the subtype Scatter with Smooth Lines.

Result:

Note: we added a horizontal and vertical axis title. The horizontal axis of a scatter plot is a value axis, so you have more axis scaling options (the same as a vertical axis which always is a value axis).

If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.