finding the coordinates of the maximum point on a graph

  • Thread starter Thread starter Guest
  • Start date Start date
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/tips/read_chart_value/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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find corresponding coordinates on graph 1
Coordinate secondary y axis to primary y axis 2
How can i see if two points share a coordiante in a scatter graph? 1
Increasing resolution of a surface contour plot 3
Excel - Plot Coordinates in a graph 4
Help with Excel 2007 curve interpolation 1
Excel graphing and equation issues 3
Plot the undulation curve and find the rate of undulation 2

Back
Top