One simple way to address this is to use:

=OFFSET('T'!$BJ$21;1;0;MAX(1;COUNT('T'!$BJ$22:$BJ$ 3019));1)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Barb Reinhardt" wrote in message
...
I'd be willing to bet that the result for this calculation is zero.

=COUNT(T!$BJ$22:$BJ$3019)

Can you check that?
--
HTH,
Barb Reinhardt



"Feejo" wrote:

Ok I have 2 series, and 2 axis. Let's work to make one axis work.
That particular row is not deleted, but a calcules and they are put to 0
all
of them, then populated again. That is when they disapear. And I only
delette
the content on the row not the row itselve.

Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1)


"Jon Peltier" wrote:

If your Names are defined using OFFSET, with the first record of the
data as
the reference range (first argument of OFFSET), and you delete the
first
row, then there is no longer a valid reference range (you've deleted
it).

Instead of deleting the entire rows, select them and press Delete or
use
Edit menu Clear All or Clear Contents.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Feejo" wrote in message
...
My dynamic chart get empty when I delette all content, then fill with
new
one. It should auto adjust.