Differences between SeriesCollection and FullSeriesCollection

Question

I am trying to clean some auto generated code and I am rather new with the series functionality in excel. So in many websites/forums I found people using a lot more SeriesCollection instead of my generated code using FullSeriesCollection.

My code is filtering some stuff and then it is setting the x axis values of a chart so it is doing that:

.ChartObjects("Voltage").Chart.FullSeriesCollection(1).XValues = "=Parametric_Sheet!D:D"

I'm trying to know if this code is ok or not or if I can clean it.

Answer 1

Sure someone else will give more info.

At least one difference is seriesCollection is backwards compatible across Excel version.

Your code is fine for newer Excel versions but if you want to ensure compatibility across then use seriesCollection instead.