I'll start with pictures to better explain what I am trying to accomplish.
imgur: the simple image sharer This is a typical chart I work with.
imgur: the simple image sharer The Data tab that creates the graph.
imgur: the simple image sharer The starting point of data I need.
I believe working with cell C is the best point of reference because as soon as a value is seen that is when the test starts. Sometimes cell B is constantly at a given value right from the beginning so would not work in all cases. As you can see in the first picture there is a peak then a dip that follows which is data I don't want to look at. I want the first point of steady numbers, which is about .5 seconds indicated by the cross. Then at the end of that area I need it to pick up the value right before it peaks again, this is the Up direction. Then from there you can see in the picture I need to do the same for the Down direction, Start and End value.
Below is an example of another chart which is why I am having a hard time creating a universal code to find these instances.
imgur: the simple image sharer More extreme chart
imgur: the simple image sharer The Data tab that creates the graph. Cell B is now a constant at 12.53 +/- some
imgur: the simple image sharer The point in which column C sees a spike in value.
As you can see the beginning spike is just as tall as the actual Start point value that I need. As of now we input these Start/End values manually by mousing over the area we want. We do so many charts though it becomes tedious.
What I was trying to do with VBA which I'm not at that level was find that initial Start value then from there index to the first End Value. Now that End value could maybe be coded to be my starting point to find the next Start value for the Down direction. I think something like this could work but I can't wrap my head around how to even get started to do this. Any and all help is greatly appreciated.
imgur: the simple image sharer This is a typical chart I work with.
imgur: the simple image sharer The Data tab that creates the graph.
imgur: the simple image sharer The starting point of data I need.
I believe working with cell C is the best point of reference because as soon as a value is seen that is when the test starts. Sometimes cell B is constantly at a given value right from the beginning so would not work in all cases. As you can see in the first picture there is a peak then a dip that follows which is data I don't want to look at. I want the first point of steady numbers, which is about .5 seconds indicated by the cross. Then at the end of that area I need it to pick up the value right before it peaks again, this is the Up direction. Then from there you can see in the picture I need to do the same for the Down direction, Start and End value.
Below is an example of another chart which is why I am having a hard time creating a universal code to find these instances.
imgur: the simple image sharer More extreme chart
imgur: the simple image sharer The Data tab that creates the graph. Cell B is now a constant at 12.53 +/- some
imgur: the simple image sharer The point in which column C sees a spike in value.
As you can see the beginning spike is just as tall as the actual Start point value that I need. As of now we input these Start/End values manually by mousing over the area we want. We do so many charts though it becomes tedious.
What I was trying to do with VBA which I'm not at that level was find that initial Start value then from there index to the first End Value. Now that End value could maybe be coded to be my starting point to find the next Start value for the Down direction. I think something like this could work but I can't wrap my head around how to even get started to do this. Any and all help is greatly appreciated.
