Hi,

I am using Office 2010 and have a problem with the Pivot graph.

Lets say I have a worksheet called "2012" and added a new sheet called "2013".
Now I copied and pasted everything from the "2012" to "2013" since I didn't want to make all the tables and Graphs from scratch.
Then I change the data for the Pivot table in the worksheet "2013" and hoping that the graphs would also change accordingly.
The problem is that it didn't change at all.
It seems as if the Graph still pulls its information from the "2012" sheet.
How can I make the graph take the information from a different pivot table.
FYI: I renamed all the pivot tables title into "Jan2013", "Feb2013" , "Mar2013" and so on.

Thank you