I think the process you should be aiming for is modifying the pivot table,rather than creating it each time. Then it will stay connected to the chart.