Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2013, 07:19 PM
artner0112 artner0112 is offline Copying pivot table and graph to a new worksheet Windows 7 64bit Copying pivot table and graph to a new worksheet Office 2010 32bit
Novice
Copying pivot table and graph to a new worksheet
 
Join Date: Dec 2011
Posts: 2
artner0112 is on a distinguished road
Default 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
Reply With Quote
Reply

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
Copying pivot table and graph to a new worksheet pivot table aliasadi_07 Excel 1 03-11-2012 12:49 AM
Copying pivot table and graph to a new worksheet Help with a pivot table please! natsha Excel 1 02-16-2012 12:41 PM
Copying pivot table and graph to a new worksheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft