Consulting

Results 1 to 2 of 2

Thread: points on a graph

  1. #1
    VBAX Regular
    Joined
    Sep 2009
    Posts
    57
    Location

    points on a graph

    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

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Post your code as it stands and we/I'll tweak.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •