Reply to thread

Message: [QUOTE="x Saed, post: 13957280"] i've been tinkering with 2007 to unlink a pivot chart from a pivot table. I know how to do that in 2003, but i suppose i didn't manage to find equivalent procedure in excel 2007... the workaround, using paste as picture is not good enough, because the it cannot be edited anymore Pls help chscot wrote: There's not a way to do this from what I know. 14-Feb-08 There's not a way to do this from what I know. You would need to create a separate pivot table and pivot chart for each filter/view If you don't need to keep your pivot chart updating with the pivot table and just want a few "snapshots", you could filter the pivot table the way you want, then copy and paste the chart to a new workbook to "unlink" the chart from the pivot table -- Thanks Christophe This posting is provided "AS IS" with no warranties, and confers no rights. : Previous Posts In This Thread: Create separate pivot chart for each filter In Excel, Pivot Charts - When filtering in a pivot table, how do you create separate chart for each filtered set of data? As it is now, the chart update when you change the filter criteria. There's not a way to do this from what I know. There's not a way to do this from what I know. You would need to create a separate pivot table and pivot chart for each filter/view If you don't need to keep your pivot chart updating with the pivot table and just want a few "snapshots", you could filter the pivot table the way you want, then copy and paste the chart to a new workbook to "unlink" the chart from the pivot table -- Thanks Christophe This posting is provided "AS IS" with no warranties, and confers no rights. : Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Reflection Effect [URL]http://www.eggheadcafe.com/tutorials/aspnet/8cc84aa8-3b44-4037-beab-49bd76e20b9b/wpf-reflection-effect.aspx[/URL] [/QUOTE]

Verification