Skip to Content
Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
book

Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007

by Bill Jelen
April 2007
Beginner to intermediate content levelBeginner to intermediate
480 pages
17h 6m
English
Que
Content preview from Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
149
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.
Start your free trial

You might also like

Microsoft® Office Excel® 2007 Inside Out

Microsoft® Office Excel® 2007 Inside Out

Mark Dodge, Craig Stinson
What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer
How to Become a Game-Changing Leader

How to Become a Game-Changing Leader

Douglas A. Ready, Alan Mulally

Publisher Resources

ISBN: 0789736101Purchase book