View Full Version : points on a graph

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

05-11-2012, 09:35 AM
Post your code as it stands and we/I'll tweak.