Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Another question for Jon
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about tab naming and referenced cells | Excel Discussion (Misc queries) | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
Auditing Question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |