creating many similar graphs

Hi All,

I have a very basic question that has been driving me crazy.

I have 100s of data sheets that I need to create similar graphs for.

I would like to create a graph on the first sheet and then paste the second sheet such that the graph would use the numbers from sheet 2 instead of sheet 1. I have done this in the past but its been a while. I am not sure if they removed this ability in Excel 2013 or am I just missing the way to do it? Every time I try pasting, it just pastes the same graph with its original numbers. When I try paste special, I only get different image options.

Please help.

Thanks in advance.

Mac