I meant to add that the SERIES function has been around since at least Excel
4, if not earlier. It is not a worksheet function: you access it by
selecting a series in a chart. You can change the SERIES formula directly by
editing it in the Formula box, or indirectly through the Source Data dialog,
Series tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"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