excel 2007 Seriescollection.Add bug
 

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

excel 2007 Seriescollection.Add bug
 

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





On Aug 27, 10:31 pm, wrote:
Can someone please confirm if this is a problem withexcel2007.

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. Earlierexcel
versions don't do this.

Is there any way to forceexcel2007to add the series to the end of
the collection, and thereby match the behavior of earlierexcel
versions?

Thanks,

Brian Murphy