+ Reply to Thread
Results 1 to 3 of 3

finding the coordinates of the maximum point on a graph

  1. #1
    eastham85
    Guest

    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. #2
    Tushar Mehta
    Guest

    Re: finding the coordinates of the maximum point on a graph

    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 <E5647E2D-AAC3-4014-8178-7F1C5C57B722@microsoft.com>,
    eastham85@discussions.microsoft.com says...
    > how can i find the coordinatres of the maximum point on a curve plotted in
    > excel????
    >


  3. #3
    Bernard Liengme
    Guest

    Re: finding the coordinates of the maximum point on a graph

    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" <eastham85@discussions.microsoft.com> wrote in message
    news:E5647E2D-AAC3-4014-8178-7F1C5C57B722@microsoft.com...
    > how can i find the coordinatres of the maximum point on a curve plotted in
    > excel????




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1