I have an excel macro/Addin that creates pivot tables and pivot charts. I want to create a copy of the user selected Pivot Chart and corresponding Pivot Table and then redirect the new chart to the new pivot table. Coping the chart and pivot table is easy, but I cant figure out how to redirect the new chart to the new pivot table or unlink the new chart from the old pivot table. Any ideas are greatly appreciated.