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.

2. On the Insert tab, in the Charts group, choose Scatter, and select Scatter with Straight Lines.

Select Scatter with Straight Lines

Note: also see the subtype Scatter with Smooth Lines above Scatter with Straight 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.

2. On the Insert tab, in the Charts group, choose Scatter, and select Scatter with only Markers.

Select Scatter with only Markers

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