New guy here, so please go easy on me. I'm working on a project that could use two perpendicular lines to follow the cursor around on a chart. I've gotten it to work to a point, but my problem lies in what I believe to be the scaling of the PlotArea. I define the start/end of both lines as the boundaries of the PlotArea, but it is evident that they don't start directly on the boundaries. Also, as the cursor moves down and to the right, the discrepancy between the cursor and the intersection point of the perpendicular lines becomes larger. What I want to find out is how to make the two lines perfectly "in sync" with the cursor and the PlotArea boundaries. The conceptual workbook is attached in case anyone would want to take a look. Thanks in advance!
My code is placed in the Chart's sheet.
Bookmarks