Hi,

This might work.

Let's imagine that the x- and y- data are in columns A and B, and the
scrollbar is linked to C2. Set the lower and upper limits of the scrollbar
to the lowest and highest row numbers of your data-range. In another cell,
say C3, enter the formula =INDIRECT("A"&C2). Link the cursor-bar to C3.

Now as you move the scrollbar, C2 and C3 will step through the row numbers
and the corresponding x-values respectively. Since the cursor is linked to
C3, it will step through the data-points on the graph.

With regards,
B. R. Ramachandran



"Brad" wrote:

I have an x-y (scatter) graph with non-integer, all positive x values and a
scrollbar set with an upper and lower limit. As I scroll, a vertical cursor
is moved through the chart but only to integer values. I'd like the vertical
cursor bar to move to each of the actual non-integer x values in my data as
I move the scrollbar.

Can anyone point me to VBA code or a formula solution to alter the scrollbar
so that it can handle non-integers?

My thanks in advance for any suggestions.

Cheers! Brad