Copy and Paste Plot AND Data in which Pasted Plot References Pasted Data

[wjdslimjim]

Excel Gurus-

I am using excel 2013 and have run into a problem I can't seem to find a solution to after some fairly extensive searching. My problem is that I have an elaborate data table with 3 plots referencing the data and I want to be able to copy and paste the data table and plots on the same sheet while keeping the same formatting, but I want the pasted plots to reference the pasted data table as opposed to the original data table.

I understand I can make a copy of the entire sheet which does that, but I am trying to keep these plots and tables on the same sheet or else I will quickly have far too many sheets to keep track of.

I also know of the add-in PTS charts which is basically the 'replace' feature for series data. This does not really help me either because the row numbers are all different. Maybe it is wishful thinking, but this seems like a fairly simple capability excel should have.

 

[GlennUK]

How about cutting the data and plots into a new workbook, THEN close the original workbook without saving ... re-open the original workbook, and cut the data and plots from where they were pasted previously, and paste whereever you want them.