In the SERIES formula, you can only refer to cell addresses by address,
or to named ranges, which can themselves refer to cell ranges (using
OFFSET etc.) or to arrays.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Wazooli wrote:
Jon - I have a final question. The suggestion you gave me earlier works
great, but since my workbook is so bloated, the chart update time is a bit on
the sluggish side (for reference, I am using the method you detailed on your
website, using a "helper" column that updates according to the offset value).
Can I use OFFSET directly in the SERIES formula? If so, what is the syntax,
because I get an error every time I try to modify it.
Wazooli