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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Harry C" wrote in message
...
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?
--
Thanks,
Harry