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