In any version of Excel (97 through 2003) this is the behavior: you can
enter a range name into the data range box, and Excel will convert it to the
range address. You can only use range names as definitions for pieces of the
source data, i.e., for the individual Name, X Values, and Y Values ranges of
each series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Gert" wrote in message
...
Hi,

Using Series in a chart it's easy to use a dynamic range of data
within a chart. Unfortunately I'm using Excel 2000 so the series
function isn't available.
When I enter the range name Excel converts it to the real cell range.
The range name is defined as:
=OFFSET($B$1,COUNTA($E:$E)-70,0,70,1)
(translated from dutch excel version)

Is it possible to update the chart range automatically, maybe using
the named range?

Thanks for your effort.

Kind regards, Gert