I created a stacked chart linked to a pivot table. I want to copy the chart (to keep consistent formats) and link it to a different pivot table. However, when I copy the chart and go to Select Data. I can not change the link to the new pivot table. The link is grayed out.

HELP!!!