Scatter Chart

 

Straight Lines | Only Markers

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.

7/18 Completed! Learn much more about charts >
Back to Top: Scatter Chart   |   Go to Next Chapter: Pivot Tables