Closed Thread
Results 1 to 2 of 2

Want to find the difference between values through their intersecting points on Graph

  1. #1
    Registered User
    Join Date
    06-26-2022
    Location
    UK
    MS-Off Ver
    2021
    Posts
    5

    Want to find the difference between values through their intersecting points on Graph

    Hi,

    I have data in column B from Cell B5 onward. I have timestamps in column A from A5 onward.
    The graph has two lines, one is Blue and other one is Orange. Blue line comes out through the data in column E from E30 onward. Orange line comes out through the data in column F from F30 onward.

    Now, Orange line is starting from time 0:33 (hh:mm) and crossing at 0:42. In Cell G5 I want this time stamp (0:33 to 0:42) for this crossover. Also, I want a difference of B38-B47 in cell H5. B38 is the respective value of A38 (0:33). And B47 is respective value of A47 (0:42). As, orange line is above of Blue for this crossover, so “Down” should be written in cell I5. In cell J5, crossover time should be written, which can be obtained by the difference of time in cell G5 which is 0:42-0:33=9 minutes.

    At 0:42
    Orange line is starting from time 0:42 and crossing at 0:59. In Cell G6 I want this time stamp (0:42 to 0:59) for this crossover. Also, I want a difference of B64-B47 in cell H6. B64 is the respective value of A64 (0:59). And B47 is respective value of A47 (0:42). As, orange line is below of Blue for this crossover, so “Up” should be written in cell I6. In cell J6, crossover time should be written, which can be obtained by the difference of time in cell G6 which is 0:59-0:42=17 minutes.
    Please note that for time stamp of 0:33 to 0:42, there is a Down trend. So, difference is B38-B47 (smaller minus bigger cell number of column B).
    For time stamp of 0:42 to 0:59, there is a Up trend. So, difference is B64-B47 (bigger minus smaller cell number of column B).

    At 0:59
    This crossover is for only 1 minute duration. At 0:59, orange line crosses blue line and it is Down trend. Again, orange line cross at 1:00. So, in cell G7, I want a time stamp of 0:59 to 1:00. I want a difference of B64-B65 in cell H7. B64 is the respective value of A64 (0:59). And B65 is respective value of A65 (1:00). As, orange line is Above of Blue for this crossover, so “Down” should be written in cell I7. In cell J7, crossover time should be written, which can be obtained by the difference of time in cell G7 which is 1:00-0:59=1 minutes (take 1:00 as 60).

    In this way I want to get results of the complete chart.

    (Help file is Attached for further clarification)
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,756

    Re: Want to find the difference between values through their intersecting points on Graph

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...the-graph.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 06-28-2022, 11:00 AM
  2. Help/Ideas plotting intersecting points on chart
    By mrp03 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-26-2021, 12:00 PM
  3. Replies: 5
    Last Post: 01-25-2021, 04:07 PM
  4. [SOLVED] Value at intersecting points
    By alanj49 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 08-05-2018, 08:01 AM
  5. Replies: 3
    Last Post: 11-17-2017, 01:58 PM
  6. Find and Insert Intersecting Values
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-09-2009, 06:51 PM
  7. Find the time at which the difference in data points starts to increase
    By jblumGRT in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2009, 02:00 AM

Tags for this Thread

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