Recent Comments
Tag Archives: XY chart
More on trend line equations on line charts
In the previous post we saw that if a trend line equation is added to a line chart it will return the wrong coefficients if the x values are not a continuous sequence of integers, starting at 1 (click on … Continue reading
Posted in Charts, Excel, Maths, Newton
Tagged chart trend line, Charts, Excel, line chart, XY chart
1 Comment
When is an XY chart not an XY chart …?
… and whan is a blank cell not a blank cell? To answer the first one, create a simple XY chart, with a single data range of 7 rows, with a blank row in the middle. This should display as two … Continue reading
PView Function
As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading
Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA
Tagged Excel, perspective projection, PView, rotation matrix, UDF, VBA, XY chart
3 Comments
Fitting high order polynomials
This post is a follow up to Using LINEST for non-linear curve fitting and the following comments from Scott Rogers and Lori Miller. Scott found that he was getting different results from Linest and the xy chart trend line for polynomials of … Continue reading
Using LINEST for non-linear curve fitting
Update 28 June 2015: Also see Using Linest for non-linear curve fitting examples, hints, and warnings for more examples of fitting exponential and polynomial curves using LinEst. A frequent question on internet forums everywhere is how to do a least squares fit … Continue reading
Posted in Charts, Excel, Maths, Newton
Tagged curve fitting, Excel, least squares, Linest, LOGEST, XY chart
91 Comments
