excel 2007 Seriescollection.Add bug

[bmurphy]

Can someone please confirm if this is a problem with excel 2007.

When I manually add a data series to a chart, the new series becomes
the last series in the SeriesCollection object. When I add a data
series using VBA either by .Pasting or by using SeriesCollection.Add,
the new series becomes the first series on the chart. Earlier excel
versions don't do this.

Is there any way to force excel 2007 to add the series to the end of
the collection, and thereby match the behavior of earlier excel
versions?

Thanks,

Brian Murphy

 

[bmurphy]

False alarm. Sort of.

It turns out that the series numbering ended up different in Excel
2007 because Excel 2007 has different behavior while executing a
statement that does

Selection.Formula = "=SERIES(...."

If the series number is not explicitly given in the above statement,
then excel 2007 changed the selected series to be series number 1.
Earlier versions didn't do this. So the fix was easy - to just give
the series number.

Brian