Re: Another question for Jon

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jon Peltier (jonREMOVExlmvp_at_peltierCAPStech.com)
Date: 03/26/05 

Date: Sat, 26 Mar 2005 01:57:32 -0500

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

Relevant Pages

  • Re: Problem with Data Validation
    ... If ESTesters is a dynamic range calculated by using OFFSET then: ... associated named ranges ... has a cell named "AllocationShift" on the front page, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: IF Statement Help
    ... formula I suggested I used named ranges and noted what those named ranges ... Microsoft Excel MVP ... Names used in the formulas refer to: ... Second spreadsheet contains numerous pages, ...
    (microsoft.public.excel.misc)
  • Re: Named Ranges - Slow Workbooks!
    ... OFFSET is volatile. ... Array formula are quite slow because each formula requires the creation and ... minimise the amount of repeated calculation by using helper cells/columns ... > with the named ranges, the workbooks have ground to a halt. ...
    (microsoft.public.excel.programming)
  • Re: Named Ranges - Slow Workbooks!
    ... OFFSET is volatile. ... Array formula are quite slow because each formula requires the creation and ... minimise the amount of repeated calculation by using helper cells/columns ... > with the named ranges, the workbooks have ground to a halt. ...
    (microsoft.public.excel.misc)
  • Re: How to dynamically change the series range of a chart ?
    ... Then if you get the chart series to point to "DataRange" as indicated ... Excel reports a "The formula you typed contains an error" when I try to ... I cannot get OFFSET to work on this... ... Series can refer to *names* rather than explicit ranges. ...
    (microsoft.public.excel.programming)