Tag Archives: Trend line

Displaying trend line equations on line charts

Posted on April 16, 2017 by dougaj4

This post is prompted by a recent comment at Using LINEST for non-linear curve fitting which found that the trend line formula displayed on a chart was totally different from that found using the Linest function. The problem was caused by using a … Continue reading →

Posted in Charts, Charts, Excel, Maths | Tagged , , , | Leave a comment

Chart Trend Lines and the Linest Function

Posted on November 3, 2009 by dougaj4

At the Mr Excel discussion forum the output of the worksheet function Linest(), compared with chart trend lines raised a question, where it is said that in Excel 2007 the trend line gives different (and incorrect) coefficients for a polynomial curve … Continue reading →

Posted in Excel, Maths | Tagged , , , , | 1 Comment