 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2007Change source data in a pivot chart
Hi All I have a stack of pivot tables each with a pivot chart. I now need to move the location ot the Pivot tables which is the source data to the charts. But in Chart=>Source data.. is dimmed out and i can't find a way of changing the pivot chart's pivot table location. Any suggestions?? TIA jpohnb Did you try moving the pivot table to see what would happen? I just did a quick test with a pivot table and standalone chart. I cut the pivot table and copied it to a different sheet, and the pivot chart knew where the pivot table ended up. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Hi All > [quoted text clipped - 9 lines] > TIA > jpohnb Hi Jon Thanx for the reply. Like many user requests this job started out as single pivot chart with a pivot table supplied with data from an excel query which in turn extracted data from a Access db. But its now expanded over the years to 30+ PC's and PT's and the associated queries are a pain to maintain. So I've decided to use an ADO connection straight into the Access db to grab the data and create the Pivot tables using VBA in a standard module, its works great. I now need change the Source Data for each chart to point at the new PT's and I can't do it! So I'd be grateful if you can cast some light on this problem. Kind regards johnb > Did you try moving the pivot table to see what would happen? I just did a > quick test with a pivot table and standalone chart. I cut the pivot table [quoted text clipped - 21 lines] > > TIA > > jpohnb Sounds complicated. Wouldn't it be easier to ditch the old chart and create a new one, since you're creating the PTs via VBA anyway? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Hi Jon > [quoted text clipped - 45 lines] >> > TIA >> > jpohnb Jon Yes. In the absence of an easy solution. I'm going to create the charts using VB. What on earth possessed me to become an IT man?? Jon Thank you for your help regards johnb > Sounds complicated. Wouldn't it be easier to ditch the old chart and create > a new one, since you're creating the PTs via VBA anyway? [quoted text clipped - 55 lines] > >> > TIA > >> > jpohnb |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.