Dynamic Shapes on Chart

**senuba91** · 03-09-2015, 04:25 PM

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.

Please Login or Register  to view this content.

**Andy Pope** · 03-10-2015, 05:21 AM

The shape x and y values are on a different scale to the mouse x and y values.

try adding a fudge factor

Please Login or Register  to view this content.

But it's more complicated than that as zoom setting has an affect.

**senuba91** · 03-10-2015, 09:32 AM

That's made a considerable improvement at a magnification of 100%. I think at this point it'll just take setting up some scenarios to accurately gauge the relationship between zoom factor, shape scaling, and mouse scaling. Thanks, Pope!