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

G

Guest

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
 
G

Guest

Plot a line graph. Right-click anywhere on the line > Choose "Add TrendLine"
then make the options in the dialog ..
 
S

Stan Brown

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
Click to expand...

You can get our attention without shouting.

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

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Combination Chart Types Access 2010 0
Insert multiple .dat files into one pdf without losing color of their graphs 0
How do you put a line of best fit on a graph? 1
Going From Excel 97 To Excel 2007 Questions From Sr. Citizen, Please 1
best tutorials for graphs ( line of best fit) for excel 2
line of best fit/reading values from graphs 4
Excel Chart Customization 1
line of best fit 3

Top