Scrollable crosshair on chart
 

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

Scrollable crosshair on chart
 

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

Scrollable crosshair on chart
 

Bernard,

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


"Harry C" wrote:

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