If Loops and Chart Series

I have a macro that takes a .csv file with lots of data, then selects the important data and plots a graph and outputs a .xlsb file.

There are some check boxes on a user form that allow the addition of some points of interest on the graph; each point of interest is plotted as a new series and it works great when all four options are selected.

If, however, only the last two points of interest are required, then check boxes 1 & 2 are left blank and the macro falls over..

It fails to work because the series are numbered in the syntax, but if the first two points weren't plotted then those series dont exist, so when I refer to the series that I do want, it should be 2 numbers lower in name.

Is these something clever that can be done here with series indexing?

Please Login or Register  to view this content.

So I have found a work around for this problem...

Code below..

Please Login or Register  to view this content.

I'm basically hiding the series, but they still exist.

not elegant, but works for me.