Thread
:
Automatic Chart Update?
View Single Post
#
4
Don Guillett
Posts: n/a
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
Reply With Quote