Curve's turning point.

[samuel]

I wish to get the turning point in my curve.
When I click the curve, excel shows a series of yellow dots on that curve.
Its seems that it is exactly what I want.
But I am curious how excel calculate those yellow dots.
Regression model or calculus?
Your help on this will be greatly appreciated.
Best Regards,
--Samuel

 

[Jon Peltier]

What kind of chart is it? Scatter or line chart with smoothed lines? If so, Excel
uses a bezier fit to draw the curved segments. For more information, check out this
file from Brian Murphy:

http://xlrotor.com/Smooth_curve_bezier_example_file.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[samuel]

Thank you very much. My chart is scatter.
I have known the answer.
Excel will always divide curve into 14 segments.

Regards,
--Samuel