A macro that makes a (line) graph move (update) ..

[JamesKM]

for incremental values of 1 to 100.

I thought Walkenback's book would help (and the attached CD) but I cannot work out what to do -

I have a graph in sheet (graph) and the data in sheet (data).
Cell named "DayRate" is the variable I want to change from 1 to 100 and view the graph moving through the 100 points.

I have:
__________________
Sub StartMove()
On Error Resume Next
Range("DayRate") = 0
For i = 1 To 100
Range("DayRate") = Range("DayRate") + 1 / 100
Next i
Range("DayRate") = 0.5
End Sub
______________________________
in module 1 and
_______________________
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

End Sub
__________________________________

in the graph worksheet, but running the macro does not work.

Please help.

Thanks in advance,
James