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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top