Home |
Search |
Today's Posts |
#1
|
|||
|
|||
finding the coordinates of the maximum point on a graph
how can i find the coordinatres of the maximum point on a curve plotted in
excel???? |
#2
|
|||
|
|||
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 , says... how can i find the coordinatres of the maximum point on a curve plotted in excel???? |
#3
|
|||
|
|||
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" wrote in message ... how can i find the coordinatres of the maximum point on a curve plotted in excel???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel |