garydp
05-07-2012, 11:59 PM
I have some X and Y values that when plotted give a shape similar to a parallelogram.
Is there a way in vba to find the four points of the graph? i have found the lowest and the highest point by using a loop and checking if the next value is more or less than that that is held by a variable.
what i cant find is the highest point on the negative side and the lowest point on the positive side of the graph.
Any help would be appreciated
Is there a way in vba to find the four points of the graph? i have found the lowest and the highest point by using a loop and checking if the next value is more or less than that that is held by a variable.
what i cant find is the highest point on the negative side and the lowest point on the positive side of the graph.
Any help would be appreciated