Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- P-Y Curve function
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- The history of the theory of beam bending - Part 1
- Drawing in Excel 7 - Creating drawings from coordinates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
Recent Comments
Tag Archives: Trend line
Displaying trend line equations on line charts
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 Chart, Excel, Show trend line equation, Trend line
Leave a comment
Chart Trend Lines and the Linest Function
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