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