ExcelBanter - For graphs how do i put a line of best fit?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - For graphs how do i put a line of best fit? (https://www.excelbanter.com/new-users-excel/139848-graphs-how-do-i-put-line-best-fit.html)

watevva

For graphs how do i put a line of best fit?

I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
AUTOMATICALLY BUT I HAVE NO CLUE HOW TO

Max

For graphs how do i put a line of best fit?

Plot a line graph. Right-click anywhere on the line Choose "Add TrendLine"
then make the options in the dialog ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"watevva" wrote:
I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
AUTOMATICALLY BUT I HAVE NO CLUE HOW TO

Stan Brown

For graphs how do i put a line of best fit?

Fri, 20 Apr 2007 20:16:02 -0700 from watevva
:
I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
AUTOMATICALLY BUT I HAVE NO CLUE HOW TO

You can get our attention without shouting.

Right-click on the graph of data points, "Add trendline".

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Bernard Liengme

For graphs how do i put a line of best fit?

But if you want to use the values (slope, intercept, r2) in the worksheet
then use the appropriate function SLOPE, INTERCEPT, RSQ - or use LINEST
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"watevva" wrote in message
...
I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
AUTOMATICALLY BUT I HAVE NO CLUE HOW TO

All times are GMT +1. The time now is 08:45 AM.