Thanks for the help.

Mike

On Sun, 26 Dec 2004 07:12:09 -0600, "Don Guillett"
wrote:

One way is to define a named range that is self adjusting and use that as
your series.
insertnamedefinename it sometingin the refers to box type
=offset($a$1,0,0,counta($A:$A),6) Look at HELP index for OFFSET and adjust
in your series, type in (modify to suit)
=myworkbook.xls!myseries