View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jeff Standen Jeff Standen is offline
external usenet poster
 
Posts: 49
Default Charts smooth lines

If it's the same as the TREND function, it's the least squares method.

http://mathworld.wolfram.com/LeastSquaresFitting.html

Or any other Google result you like :)

Cheers,
Jeff

"fred" wrote in message
...
Can anyone tell me the equation of the line the excel uses to show a
"smooth" line between points on a scatter chart?

Thanks
Fred