Quote:
Originally Posted by Excel Poser
I want to replicate an XY chart from Worksheet #1 into a new chart on Worksheet #2, but keeping the cell references exactly the same on each worksheet. By simply copying and pasting, the source data on the new chart in Worksheet #2 continues to point to the cell references on Worksheet #1. I want it to point to its own unique data values on Worksheet #2. Without a workaround, I must manually re-enter all the 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 pasting the second worksheet over this new one? You can then delete sheet 2.
I'm not sure there is an easier way.