You are attempting to create a chart by using a PivotTable report in another workbook. This will result in a static chart ...

You are attempting to create a chart by using a PivotTable report in another workbook. This will result in a static chart that cannot be updated. To create a PivotChart report, or a chart that dynamically updates like the PivotTable report, the chart must be located in the same workbook as its associated PivotTable report.