Advancing this somewhat... is there a way to deal with multiple series in the
same data column?

The data is sorted so that the each series is in an unknown range in the
column i.e. the range changes as data is added. Thanks in advance for your
help..... Tony G

"Don Guillett" wrote:

Glad it helped

--
Don Guillett
SalesAid Software

"Mike Fox" wrote in message
...
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