+ Reply to Thread
Results 1 to 2 of 2

Maximum value in Excel Graph

  1. #1
    Registered User
    Join Date
    05-29-2017
    Location
    sydney,australia
    MS-Off Ver
    2007
    Posts
    1

    Maximum value in Excel Graph

    Untitled.jpg

    Hey guys I need to find the maximum point on the curve and then have the perpendicular line from the max point towards the axes. Please see the attached file.

    Untitled.jpg

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Maximum value in Excel Graph

    With only three points to define the curve, I would expect to use a process like this:

    1) Regress equation for curve. Assuming you are looking for a polynomial (quadratic with only three points) or other linear function, you can use the LINEST() function (https://support.office.com/en-us/art...a-fa7abf772b6d ) for this step, or you can use the built in trendline feature of the chart ( https://support.office.com/en-us/art...4-901a745842ad ). If your desired curve is nonlinear, then you will need to use non-linear regression techniques.
    1a) If you use the chart trendline feature, you will need to enter the coefficients of the quadratic/polynomial/trendline into spreadsheet cells.
    2a) Assuming you use a quadratic equation, then you can use simple algebra that you learned back in school to find the maximum point. A quick refresher: http://www.purplemath.com/modules/perimetr6.htm
    2b) If you use a different equation form, you will probably enter the calculus realm, where you find the zeros of the first derivative.

    Note that, except for possibly using the chart to perform the trendline regression, the chart does not actually perform the analysis. The analysis is performed in the spreadsheet.

    Is that enough for you to work out the details, or is there a specific step that you get stuck on?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Maximum number of ranges in an Excel 2010 line graph?
    By Carrfamily in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-31-2015, 04:47 PM
  2. Export Maximum peak value on graph to a cell
    By rusty_cool2002 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-02-2013, 08:59 PM
  3. [SOLVED] Is there a maximum number of columns available to put into a line graph?
    By Luch in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 09-18-2012, 12:52 PM
  4. mixed graph maximum bars
    By pkm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2007, 03:07 AM
  5. how can I mark the maximum point on x-y graph
    By MAJ-BEHNAM in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-30-2006, 06:40 AM
  6. finding the coordinates of the maximum point on a graph
    By eastham85 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2005, 10:06 AM

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