+ Reply to Thread
Results 1 to 9 of 9

To Find the difference of values through their crossing points on the Graph

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

    To Find the difference of values through their crossing points on the 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
    79,339

    Re: To Find the difference of values through their crossing points on the Graph

    Administrative Note:

    Welcome to the forum.

    Unfortunately, it has come to our attention you have violated Rule #8 of our Forum RULES:

    Don't private message, visitor message or email Excel (or Access, Word, etc.) questions to moderators or other members.

    All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

    Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to a permanent ban, so do take this caution to heart.
    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.

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

    Re: To Find the difference of values through their crossing points on the Graph

    Hi, AliGW

    Thank you for guiding me about this. From the next time i will not break any rule.

    I have read all the rules now.

    Thanks

  4. #4
    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
    79,339

    Re: To Find the difference of values through their crossing points on the Graph

    From the next time i will not break any rule.
    Have you read them? It seems not - I have just closed your duplicate thread.

    Please read them now: https://www.excelforum.com/forum-rul...rum-rules.html

    Thanks.

  5. #5
    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
    79,339

    Re: To Find the difference of values through their crossing points on the Graph

    And another rule broken!!!

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I will do it for you today: https://www.mrexcel.com/board/thread...graph.1209098/

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

    Re: To Find the difference of values through their crossing points on the Graph

    Hi, AliGW

    I am really sorry on this. I thought i would may get solution from that site. But I have done this in a wrong way and have wasted my time. Now please guide me further what should i do to get an answer from this forum. Should i ask Mr Excel forum for to remove that thread which i started or something else.

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

    Re: To Find the difference of values through their crossing points on the Graph

    Have you seen Andy Pope's solution for this kind of problem? https://andypope.info/charts/intersection.htm
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: To Find the difference of values through their crossing points on the Graph

    Hi MrShorty

    Thank you Sir for your reply.

    Apparently it looks like solution of my problem is in this Andy Pope's solution.
    I am new to Excel and have very little knowledge about Excel formulas. I am unable to make modification according to my need as explained in this thread.

    Can you please Sir make modifications according to my need in this attached file.

    I will be really very thankful to you
    Attached Files Attached Files

  9. #9
    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
    79,339

    Re: To Find the difference of values through their crossing points on the Graph

    Should i ask Mr Excel forum for to remove that thread which i started or something else.
    No - you just need to tell them that you have also posted the question here with a link. Please read the rules carefully: it's all explained there.

+ 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. [SOLVED] Measuring a graph crossing if x is met
    By Median in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2018, 07:40 PM
  2. [SOLVED] Tiimelog - Time Difference Crossing Over or Past Midnight
    By mycon73 in forum Excel General
    Replies: 6
    Last Post: 10-20-2016, 06:41 AM
  3. Find crossing points based on a given condition
    By jmnpinheiro in forum Excel General
    Replies: 4
    Last Post: 09-02-2014, 03:00 PM
  4. [SOLVED] formula to calculate time difference crossing midnight
    By ditorejax in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-06-2014, 08:27 PM
  5. Crossing points in two columns of data
    By worswick25 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2011, 07:17 AM
  6. 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
  7. How do I find value on a graph between data points?
    By Banio in forum Excel General
    Replies: 5
    Last Post: 10-30-2005, 09:05 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