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