Series equivalent in Excel 2000

[Gert]

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

 

[Jon Peltier]

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
_______

 

[Jon Peltier]

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/
_______