how to copy XY charts into new worksheet?

[Excel Poser]

I want to replicate an XY chart from Worksheet #1 into a new chart o
Worksheet #2, but keeping the cell references exactly the same on eac
worksheet. By simply copying and pasting, the source data on the ne
chart in Worksheet #2 continues to point to the cell references o
Worksheet #1. I want it to point to its own unique data values o
Worksheet #2. Without a workaround, I must manually re-enter all th
source data on Chart 2 and my XY chart has over 100 unique series
therefore it's very labor intensive. Thank you

 

[Spencer101]

I want to replicate an XY chart from Worksheet #1 into a new chart o
Worksheet #2, but keeping the cell references exactly the same on eac
worksheet. By simply copying and pasting, the source data on the ne
chart in Worksheet #2 continues to point to the cell references o
Worksheet #1. I want it to point to its own unique data values o
Worksheet #2. Without a workaround, I must manually re-enter all th
source data on Chart 2 and my XY chart has over 100 unique series
therefore it's very labor intensive. Thank you.

How about making a copy of the first worksheet then copying and pastin
the second worksheet over this new one? You can then delete sheet 2.

I'm not sure there is an easier way