View Single Post
  #1   Report Post  
Chris Manning
 
Posts: n/a
Default Can I grab graph coordinates in Excel via the mouse with VB?

Is it possible to get the graph coordinates (i.e. the y coordinate of a
graph) in Excel using Visual Basic coding (or other methods) and insert them
into another cell? Specifically ,what I want to do is have the user click on
a graph, and have the y-coordinate at the time of the click entered into a
cell, or, alternatively, have the user click and drag across the graph and
have the coordinates at the beginning click and at the end of the drag
entered into two seperate cells. Further, the complete set of y-coordinates
is a column of data points, not a fcn if that helps at all.