I created a pivot chart in one worksheet. I did some formatting on the chart.
Then I made a 2nd copy of the worksheet wanting to re-use the same format.
However, the 2nd pivot chart is still point to the first pivot table. How do
I reference the 2nd chart the new pivot table?