Charts/XY(scatter)/Smooth lines option

I

IAN

I would appreciate your help in the following issue:

We like to know what function the Excel developpers have used in Excel for
Charts/XY(scatter)/smooth lines. It iseems to us that it is a B-spline but
there are many of those around. Could you please provide us with the exact
spline function used for interpolation in this Excel option and possibly the
code

Thanks a lot in advance
Ian
 
I

IAN

Dear Jon,

Thanks for the message. I followed your advise but it seems that the code in
Brian's web site is only for 4 points. In Excel we can give any number of
points without restrictions and Excel gives us the smoth line.
I would appreciate your advise

Thanks in advance

Ian
 
J

Jon Peltier

What are you using the smoothed lines for? Not to interpolate values between
plotted points, I hope, because the curves hold no information about the
values between the points.

I haven't looked at Brian's workbook in a couple of years, so I forget how
he did it. Couldn't you extend the formulas, or loop more in the code, or
extend whatever technique he uses?

- Jon
 
I

IAN

Dear Jon,

I have a table of X and Y which are more than 4. Normally Bezier is for 4
points. By interpolating with Excel I can get a smooth line from several
input points but not the values in between. In Brians code you can in fact
take the interpolated values between the original interpolated points
according to a step. However it has as an input only 4 points. It seems
difficult to me how to extend it since it is not straight forward. I think
Brian should have done it and if he can help I would very much appreciate

Thanks again

ian
 
J

Jon Peltier

As I recall, two adjacent points in the chart form the outer pair of points
in the Bezier curve, and Brian includes algorithms for determining the inner
two. You need to do the analysis between every adjacent pair of points in
the series.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top