Copy/Paste Chart to Sheet2, but Data is Still referenced from Sheet1. How do I update it?

[Melissa60515]

I have two almost identical worksheets. Sheet 1 & Sheet 2.
I want to make a chart for each of them.
I want to keep Chart 1 on Sheet 1. And I want to keep Chart 2 on Sheet 2.
The charts are exactly the same, but very tedious.
I just finished Chart 1 (on Sheet1), and want to copy it over to Sheet2, and just dynamically update all of the data on the 2nd chart, to reflect Sheet 2.

Does someone more savvy than I know how to achieve this magnificent feat?

Much appreciated!
`````````````````````````````````````````
Reworded:
I have Data+Chart on Sheet1.
If I copy everything to Sheet2, how do easily I make the new chart on Sheet2 reference the data on Sheet2 (instead of Sheet1)?
Thanks!

[lcartwright]

Maybe I am not understanding the question properly but,

Right click on your Chart 2 in Sheet 2, and Select Data to the cells on Sheet 2?

[Melissa60515]

Thanks for the reply, however, if I click:
Select Data, Edit, I have to change each and every "Legend Entry (Series)" individually to reference Sheet2 (instead of Sheet1).
There are currently 20 Series. That would take a LOT of time, and is subject to error.
I am curious if there is a way to change ALL LEGEND ENTRIES to reference Sheet2 (instead of Sheet1)