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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Plot a line graph. Right-click anywhere on the line > Choose "Add TrendLine"
then make the options in the dialog ..
 
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".
 
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
 
You must log in or register to reply here.

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

Graphing Question: Blank Lines Problem ? 2
How do you put a line of best fit on a graph? 1
Access Combination Chart Types Access 2010 0
Insert multiple .dat files into one pdf without losing color of their graphs 0
Going From Excel 97 To Excel 2007 Questions From Sr. Citizen, Please 1
best tutorials for graphs ( line of best fit) for excel 2
Excel How to change lines in graph to individual colours 0
how to make a bar graph 1

Back
Top