Movable crosshair on chart with mouseover event

[Hendra S]

I have an XY scatter plot and I'd like to add some vertical-horizontal lines (cross-hair) on the plot.

Is it possible since these lines could also be moved along the x & y axis and follow mouse pointer when chart activated (I guess it required mouseover event) ?
I'd like the x and y value of the data point on the curve to be displayed within the chart. The location of the data point will vary, so the system needs to be dynamic.

better explanation can be found in the attachment.

[Andy Pope]

An alternative to mouseevents on the chart
http://www.andypope.info/ngs/ng26.htm

Info on chart events
http://www.computorcompanion.com/LPMArticle.asp?ID=221

[Hendra S]

Andy,

I've developed scrollable hair line based on your reference link. instead of modify the marker, I utilize Y-error bars as a vertical line and control toolbox. I link the maximum Y value to Chart_data (cell: P24).
(excel file can be found in the attachment of this post)

On my first attempt, I link Y-error bars max value to scale max value (cells:S28). but if I change series option (cell: K27), I get strange result, which min/max value for series-1 will give different value than max value in the chart. Is it possible to tackle this issue ?

I've also tried to implement simple cross-hair into userform, but when mouse pointer cross the image area, the cross-hair "freeze".

B'rgrds
Hendra S

[Andy Pope]

This uses a plus/minus 100% Y error bar. The Y position is in the center of the primary Y axis.

When determining the Y axis scales the point is set to 1 in order to not influence the Auto scaling.

[Hendra S]

Andy,

nice trick to tackle auto-scaling interference. that's the sort of thing I'm after.
Thanks very much for all your help


B'rgrds

Hendra S