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