Store variable value for Chart

[Al Jager]

The value of a cell changes randomly during the day as a
result of a web query i.e. at 10:00 AM the value is 2.3 at
10:15 AM the value is 2.54 etc. How can I store the
individual values so that I can create a chart that
depicts these changes graphically.
Many thanks

Al

 

[BrianB]

You need to have a variable to store the target row number and incremen
it with each cycle of the macro (don't forget to initialise it at th
beginning of the macro with rw=0 or whatever).

Something like :-
'--------------------------------------------------------------------
rw = rw + 1
Worksheets("DataStore").Cells(rw, 1).Value = MyTime
Worksheets("DataStore").Cells(rw, 2).Value = MyValue
'----------------------------------------------------------------------