SeriesCollection(2).Formula returns formula for series 1
 

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

SeriesCollection(2).Formula returns formula for series 1
 

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Brian Murphy" wrote in message
...
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