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.