Excel chart smoothing algorithm

[artz]

I recently showed an Excel chart during a presentation on which I had used the built in Excel option of "smoothed line" from the Format Data Series menu. I was challenged as to the validity of the smoothing and was asked to identify the algorithm used by Excel. Do we have an expert in the group who could show how Excel smoothes lines in the graphs? A sample worksheet would help.

Thanks,

Art

 

[tusharm]

Yes! Most Microsoft MVPs who are interested in this kind of material, myself included, would have pointed you to the xlrotor work! It's good that you persevered and found it for yourself.

BTW, was able to find a worksheet which demonstrates the Bezier smoothing method used by Excel. See the following link:

http://xlrotor.com/Smooth_curve_bezier_example_file.zip

Art