Scrollable crosshair on chart

[Harry C]

Hi,

I am plotting x-y scatter data and would like to be able to create a scroll
bar that would control a crosshair that is linked to the datapoints, so that
by moving the slider I can move the crosshair throughout the data points
shown on the chart. I want the crosshair to be linked to each datapoint. Is
it possible to do this with one scroll bar, perhaps linked to row number, or
some such data index variable?

 

[Bernard Liengme]

Would take too long to explain.
Look here http://people.stfx.ca/bliengme/exceltips/crosshairs.xls
Come back (here or to me personally - email found on my website) for more
into
best wishes

 

[Harry C]

Bernard,

That solves my problem! Great stuff. Now, is it possible to display the
crosshair lines to the axis limits?