I have put my values into a XY scatter graph but need to find the maximum point i.e when the gradient is zero. I am using visual basic to obtain my data and draw my graph.
Calculate Maximum Point On Curve From Xy Scatter Graph
-
-
-
Re: Finding Max Point On Curve From Xy Scatter Graph
Can you post example of your chart and tell us which value you think should be reported.
-
Re: Finding Max Point On Curve From Xy Scatter Graph
Chart Name forum.ozgrid.com/index.php?attachment/25754/
The point at the top of the peak is one i wish to find
hope u can view it, new to the forum world
-
Re: Finding Max Point On Curve From Xy Scatter Graph
Can you not use the max worksheet formula?
MAX(<yvalues range>)
Or with code
[vba]
Msgbox application.WorksheetFunction.Max(activechart.SeriesCollection(1).values)
[/vba] -
Re: Finding Max Point On Curve From Xy Scatter Graph
Personally I don't see any data.
Perhaps an Excel file would be better -
-
Re: Finding Max Point On Curve From Xy Scatter Graph
The line on my graph is a smooth scatter, so the point at the peak is not one i have imput, finding the equation of the line on my graph would be a help if could differentiate it through vb, but all attempts to find the equation of the line has failed because i can only get equations of trend lines.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]forum.ozgrid.com/index.php?attachment/25755/
here is the file minus the code because its to big with it
-
Re: Finding Max Point On Curve From Xy Scatter Graph
cubic spline or bezier curve calculations are needed.
Dave Braden
http://groups.google.com/group/microsof…a2966520eccdb1fBrian Murphy has shown that the Excel chart smoother appears to use Bezier
curves.
http://www.xlrotor.com/resources/files.shtml -
Re: Finding Max Point On Curve From Xy Scatter Graph
Explains a lot and has helped
Thanks
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!