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


--
Don Guillett
SalesAid Software

"Mike Fox" wrote in message
...
Is there a way to automatically update a chart when a data point is
added without redrawing the chart? Went to Tool/Options/ Calculate
tab and the automatic update feature is checked.

I'm running Win XP Pro with Office Pro.

Thanks

Mike