how to animate the XY Scatter chart

[dipspharma]

hello,
i am dipak solanki.
i want to prepare the animated chart for variable processes.
in which x axis contains time range while y axis contains variable processes.

 

[dipspharma]

i have applied Below mentioned commands but it was applicable for only one process but i want to multiple process.

Sub Animate1()


For i = 1 To 100


Cells(3, 2).Value = i


DoEvents


Next i


End Sub