Category Archives: Charts

Using LINEST for non-linear curve fitting

Posted on 19/01/2011 by dougaj4

Update 14 March 2020: See LinEstGap with non-linear functions for the latest version of Linest-Poly with new functions for non-linear curves allowing more convenient input and work with data with gaps errors, and/or hidden lines. Update 28 June 2015:  Also see … Continue reading →

Posted in Charts, Excel, Maths, Newton | Tagged , , , , , | 96 Comments

Faster Ferns

Posted on 03/10/2010 by dougaj4

I have modified the fern input parameters in the spreadsheet presented in the previous post to match the layout used by Barnsley and others, so that examples such as those given at the Wikipedia article can be entered directly.  The … Continue reading →

Posted in Arrays, Charts, Charts, Drawing, Excel, Maths, Newton, VBA | Tagged , , , | 4 Comments

Secondary axes in Excel 2007

Posted on 20/02/2010 by dougaj4

Sometimes rarely used features in an application are so prominently placed that we become blind to them, and can’t find them when we need them. This happened to me recently with the procedure for assigning an Excel chart series to … Continue reading →

Posted in Charts, Excel | Tagged , , | 9 Comments

Drawing in Excel – 1

Posted on 01/06/2008 by dougaj4

This is a the first of a series of posts describing how to produce scale drawings in Excel, based on a list of coordinates. This post will cover the use of XY graphs, or scatter charts as Microsoft likes to … Continue reading →

Posted in Charts, Drawing, Excel | Tagged , , , | 6 Comments

Section Properties UDF and UDF charting

Posted on 14/03/2008 by dougaj4

The technique for calculating section properties from coordinates is conveniently coded into a UDF: Function Area(xy_range As Variant) As Double Dim XYcells As Variant Dim N As Long, NumX As Long Dim XD As Double, YSum As Double XYcells = … Continue reading →

Posted in Arrays, Charts, Excel, UDFs | Tagged | 6 Comments