Using XY Scatter Charts to Plot Pairs of Data Points
The chart in Figure 5.2 shows a relationship between latitude and temperature: as latitude
increases, temperature decreases. You can therefore say that latitude and temperature are
inversely related.
5
If your data is not sorted,you should be sure to choose Scatter with Only Markers as the chart type.
TIP
Adding a Trendline to a Scatter Chart
To add a tight grid and a trendline to a scatter chart, you choose Layout 3 from the Chart
Layouts gallery on the Design ribbon. The trendline represents the best-fit line, given the
data points. If the trendline is angled diagonally from bottom left to top ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.