SeriesCollection(2).Formula returns formula for series 1

[Brian Murphy]

This is really weird.
I've got a basic XY chart with 4 series on it.
In VBA I'm having
SeriesCollection(2).Formula
and
SeriesCollection(3).Formula
both return the formula for series number 1.
Series numbers 1 and 4 work ok.

I tried changing the DisplayBlanksAs property, but it had no affect.

Does anyone know why this would happen?

It even does this in the immediate window, and in the Watches window.
Restarting excel made no difference. I'm using excel 2003.

Thanks,

Brian Murphy

 

[Jon Peltier]

Brian -

This sounds vaguely familiar, I think I ran across something like this a
while ago. I don't remember how (or whether) I fixed it, but if you email me
your file, I might be able to remember.

- Jon