Macro to extend series data without specifying the name or column

Hi all.

I have a large data set and currently the series data only goes until A2:A350 or so. Is there a where to expand both the x and y data of that series to say A2:A900?

A main issue I have is that there is a large number of data sets and all are very variable - therefore, is there a way to extend the data set without naming the Series name or the column - i.e A2:A900. Can I effectively add more cells to the current data set using offset?

Thanks

Thanks for your reply.

However, due to the large number of series and variability between what is in the series I was hoping to be able to extend the range of the current series in a chart without specifying the actual series or column

Would this be possible through - SeriesCollection(1)?

Is this a range (A2:A350) which is used in a code? If so, you can make it flexible.

Something along the lines of -

Please Login or Register  to view this content.

Hi, not as such.

Say for example one of my series is B2:B400, however when updating the data set the data goes to B800. This can happen to many series and it is rather unpredictable as to which/series need to be extended.

Is there a way to scroll through every series and extend that range?