Pivot Charts - Copy And Repoint
In Excel 2007, it is not directly possible to change the data source for a pivot chart, but this code that shows how to copy a worksheet while repointing the pivot charts to the copied pivot table, rather than the having them reference the source pivot table.
Right-click to Save Target As: VBA_CopyAndRepoint.txt