Yes, this is an existing chart with an X and two Y's. Didn't want to muddy
the water with too much information before, but this is all contained in a
humongous macro-rich workbook that serves as a template for numerous users.
The user imports from a raw data file (Excel), does a whole series of things
to it, and one of several results is the data in the worksheet that feeds
this chart. And wouldja believe, with some source files it works and with
some (or at least one!), the aforementioned error occurs.

The infamous Column E, which appears to be the root of the problem, starts
out with formulas all the way down, but to prevent Excel from charting
zeroes, the very last VBA step just before trying to reset the chart series
evaluated the whole column and sets everything that isn't a valid, 0 number
to null.

Don't know if that will ring any Aha! bells, but I sure appreciate your
sticking with me through all this.

"J Sedoff" wrote:

(Stupid question, I know, but it can't hurt...) And you know that the chart
you are trying to modify already has two y-variables set up? I'm not sure if
it would screw up if you didn't have a second series previously set up, but
maybe it's a shot (in the dark, *cough*).

Jim
--
I appreciate any feedback. Please don''t be scared to say that "Yes"
I/someone else did answer your question. Thank you.