View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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