How to Create Scatter Chart In Excel

Oct 27, 2020 • edited Oct 30, 2020

How to Create Scatter Chart In Excel

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

Straight Lines

To create a scatter chart, execute the following steps.

1. Select the range A1:D22.

Select Scatter Chart Data

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

Insert Scatter Chart

3. Click Scatter with Straight Lines.

Click Scatter with Straight Lines

Note: also see the subtype Scatter with Smooth Lines.

Result:

Scatter Chart with Straight Lines in Excel

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

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.

Select Scatter Chart Data

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

Insert Scatter Chart

3. Click Scatter.

Click Scatter

Result:

Scatter Chart with Only Markers in Excel

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

#Tutorial#How To#Data Analysis

How to Create Outlining Data In Excel

How to Create Thermometer Chart In Excel