Moving a chart from one sheet to the next with dynamic data

Hi,

I'm a bit of a newbie to even this level of excel. Essentially, my goal is to track the progress of my team members individually. I have rows of data on one sheet for each them, and I want to make a chart based upon it. I did this for one member, but when I copy the chart to the next sheet it references the first sheet's data. Is there a way I can copy a chart from one sheet to the next and have it look at the same rows for information on that new sheet?

Thanks,

Kyle

A better way of asking this is the following: Right now, when I copy the chart from a sheet named 'Doe, Jane' to 'Smith, John', the chart's data remains as 'Doe, Jane'!$B$2:RB$20. How can I get it to change which sheet the data comes from on a copy?