+ Reply to Thread
Results 1 to 2 of 2

Cumulative distance between intercept points on Excel graphs

  1. #1
    Registered User
    Join Date
    03-07-2009
    Location
    Cardiff
    MS-Off Ver
    Excel 2007
    Posts
    1

    Cumulative distance between intercept points on Excel graphs

    Hi there, hoping you can help with the following:

    Looking at the chart below, it is possible to use an excel formula/VBA to calculate the cumulative time below a certain value of x (as indicated by the arrows I've added to the chart)?

    NB The graph shows the variation in tide height (x) over time (y).

    The graph looks like this:

    http://i264.photobucket.com/albums/i...d/Graph1-1.jpg

    The data looks a littles something like this : (extract)

    http://i264.photobucket.com/albums/i...road/Data1.jpg

    Really stumped on where to begin with this one; any suggestions or input would be very gratefully received.

    Stuart

    (Excel 2007 & Windows Vista)
    Attached Images Attached Images

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Cumulative distance between intercept points on Excel graphs

    Welcome top the forum.

    If you want help with workbooks, please post workbooks instead of pictures.
    Entia non sunt multiplicanda sine necessitate

+ 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