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.

You need a Dynamic Chart. Define a named range by pressing Ctrl-F3,
enter a name in the Name Box (like TimeValues), and enter this formula
into the Refers To box, and click Add:

=OFFSET(Sheet1!$A$102,0,0,COUNTIF(Sheet1!$A$102:$A $2000,"0"),1)

Then add another name, DataValues, that refers to:

=OFFSET(TimeValues,0,1)

Select a cell and start the chart wizard. On step two of the wizard (or
for an existing chart, from Source Data on the Chart menu), click on the
Series tab, select the series from the list (or click Add), then in the
X Values (or Categories) box enter

=Sheet1!TimeValues

and in the Y Values box enter

=Sheet1!DataValues

(use the real name of the worksheet). Click your way through the
dialog(s) to get back to Excel with your brand new dynamic chart.

For more on dynamic charts, check out this web page, which features
examples and links:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Rudolphs wrote:

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.