#### Joe4

##### MrExcel MVP, Junior Admin

- Joined
- Aug 1, 2002

- Messages
- 70,672

- Office Version
- 365

- Platform
- Windows

I have 32 pairs of coordinates (X,Y). If I graph them using a scatter chart in Excel, I can see that it looks like they suggest a linear relationship between the points.

Other than printing the chart and trying to draw a "best fit" line manually, is there some sort of way I can get Excel to come up with the "best" linear formula (y=mx+b format)?

Thanks.