how can i find the coordinatres of the maximum point on a curve plotted in
excel????
how can i find the coordinatres of the maximum point on a curve plotted in
excel????
If you know the equation of the curve, use calculus.
If you dont, consider one of the following:
Eyeball the result.
Adapt the idea in 'Read X and Y value of any point on a chart'
http://www.tushar-mehta.com/excel/ti...lue/index.html
Search the google.com archives of the XL NGs to find code that will
give you how XL computes its smoothened line connecting the points
(Dave Braden's cubic spline code and the bezier curve courtesy
xlrotor.com). Then, use calculus with that equation.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <[email protected]>,
[email protected] says...
> how can i find the coordinatres of the maximum point on a curve plotted in
> excel????
>
If you know the equation of the curve and if you don't like calculus, you
could use Solver to find the max. I would be tempted to give some
constraints for the x-value
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"eastham85" <[email protected]> wrote in message
news:[email protected]...
> how can i find the coordinatres of the maximum point on a curve plotted in
> excel????
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks