You can get some dynamic charting in Excel 2003 if you base the chart on
data in a List, or in 2007 if you base it on a Table. However, you mention
2002, which lacks this capability.

What are your name definitions and series formulas (in 2002). There may be
alternative ways to define the names.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"goofy11" wrote in message
...
I've recently realized that Excel 2007 has a bug that is preventing me
from
using dynamic Named ranges to create dynamic charts. Several people have
noted on this newsgroup that they've experienced similar problems with
Excel
2007 charting using named ranges. In my case i get the error message "A
formula in this worksheet contains one or more invalid references." When
I
open this same workbook at home (using Excel 2002), everything works fine.
SP1 addressed something similar to the issue I'm having, but in my case
SP1
did not fix the problem. As a result I'm wondering if there are any
alternatives to using Named ranges? This is going to be a template
accessed
by multiple users from the web. As a result, it needs to be compatable
with
older versions of Excel and not use VBA.

Does anyone have any workarounds, or am I out of luck? The Series ranges
could expand or shrink.

Jeff