2 Replies Latest reply: Mar 11, 2011 6:21 PM by Barry
Asclepius37 Level 1 (0 points)
I'm not sure if this is well-known or has been answered elsewhere already, but multiple Google searches have not shown this solution on how to create a line of best fit in Numbers '09 (there is another method that involves drawing a line yourself, but this is much easier and more accurate).

I stumbled across this trying the above self-draw technique and got so excited I wanted to post the technique. So here is what you do:

1) Type out your X and Y data

2) Select the data and select Charts, then select the Scatter Plot

3) Open up Inspector and select the Chart tab

4) Select the "Series" tab below the picture of the Scatter Plot and the "Chart Colors..." button

5) At the bottom of the Inspector window, open the "Advanced" arrow

6) Select the "Trendline" tab and select the "Linear" trendline from the drop-down bar

That's it! You can even select the options to show the line equation or the R-squared value!

Here is a picture of the selected options and what your graph should look like (check that nice R-squared value!).


I hope this helps and hope it moves up to the top of the Google search page for this feature.

MacBook Pro, Mac OS X (10.6.6), -