Hello,

I'm using named dynamic ranges in a chart of mine - something I have found handy and has worked so far without any problems.

However, I've come across a strange problem whereby I have a named dynamic range that Excel claims is an invalid series when I try to plot it.

I have looked in my named ranges and whenever I highlight the series, it correctly highlights the data column range that is supposed to be plotting (so as far as I can tell, the series is valid). However, when I try to use it as a range in my chart, I keep getting the invalid message:

"A formula in this worksheet contains one or more invalid references.
Very that your formulas contain a valid path, wokrbook, range name, and cell reference."

Now I've checked the spelling, etc. of the range I'm putting into my chart's values and the name in the collection of names - and I know it's the same (done about a dozen times or so).

Any ideas what might be causing this? Could it be an Excel bug? The only think which was out of the ordinary is that I originally had the series defined one way and I later changed to read either of 2 series, depending on a user specification. The trouble series plots only zeros, but I don't see why that should be a problem.

Any advice would be much appreciated.

-Pete