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