David Braden has posted code for cubic spline
http://groups.google.com/group/micro...2966520eccdb1f
If you are interested, the Excel chart smoother appears to use Bezier curves
http://www.xlrotor.com/Smooth_curve_...ample_file.zip
Jerry
"Fabian Grodek" wrote:
Is there any way in Excel or VBA to do a spline approximation to test data
that do not follow any polynomial shape? I mean, I have data points and I
want to approximate (i.e., not necessarily pass through the points) that data
with a spline curve.
Thanks.
Fabian