how to copy XY charts into new worksheet?

E

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
 
S

Spencer101

Excel said:
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.
Click to expand...

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
 
Top