#1
|
|||
|
|||
Copying pivot table and graph to a new worksheet
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 |
Tags |
graph, pivot table, work sheet |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Table | uhlersa | Excel | 0 | 10-15-2012 12:01 PM |
pivot table | aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
Help with a pivot table please! | natsha | Excel | 1 | 02-16-2012 12:41 PM |
Worksheet copying? | markg2 | Excel | 4 | 01-07-2010 10:08 AM |
Help - I need to make this table into a graph asap - but I don't know how | Theofficehedgehog | Excel | 1 | 07-05-2009 01:44 PM |