I have a PivotChart in Excel 2016 that is currently based on PivotTable-A.
PivotTables A and B are identical, other than the fact that they have different data sources:
A‘s data source is an external data source connection.B‘s data source is an Excel table (that uses an identical external data source connection).
I want to change the PivotChart’s source from PivotTable-A to PivotTable-B. Once I do that, I’ll delete PivotTable-A.
Explanation: Change PivotTable source from external data source connection to table/range
Question: Is there a way to change the PivotChart’s source from one PivotTable to another PivotTable?
I have several PivotCharts where I need to do this. I’d prefer to avoid recreating all the PivotCharts from scratch if I can help it.
