+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    07-14-2010
    Location
    Albuquerque
    MS-Off Ver
    Mac 2008
    Posts
    33

    Graphing Template Problem

    Hi everyone, I am making a template to analyze data that generates a curve (this is electrochemical data for a cyclovoltammogram, if that helps). There are several sweeps across the independent axis (potential in this case) both back and forth. I broke my data up into sweeps, so in each sweep (say from high to low potential), I would like to find the inflection point. My approach so far has been to graph the tangent at each point on the curve. I can find the maximum value (which is the inflection point), but I would like this template to find that maximum value and give me the corresponding point on the independent axis, which is in the adjacent cell to the right.

    So in short, I want the cell next to the maximum value in an array. But note that this value next to the maximum is not the maximum value in that same column. If anyone can help me out with this I would greatly appreciate it. Thanks in advance!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,906

    Re: Graphing Template Problem

    It would probably help if you posted an example workbook
    highlighting in some way the expected results.
    Cheers
    Andy
    www.andypope.info

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.2.0