Say I have to xy scatter plots with different sets of data. I want to be able to copy and paste the series in one into the other plot. In excel it was straightforward, just click on the data you want and ctrl c and ctrl v into the plot you want it in.
Are the two plots (or charts) on the same spreadsheet or on different sheets?
They are on the same spreadsheet