Hi

Im trying to update my graph data series through any automatic(dynamic)
means possible.
But the problem is that i need to use a cells "VALUE" to set the range
correctly.
EG:
for example if part of a data series reference was A102:F506 it would
become A102:(F506 - x)
where x is the value of the cell which counts the amount of zeros in
an ordered list.

example of list:

Time Data
01:00 43
01:01 12
01:02 65
01:03 12
.. .
.. .
0 0
0 0
0 0

So i only want to graph the information with data not = to 0.

Thanks in advance.