Create multiple pivot charts [Error: Method 'SetSourceData' of object '_chart' failed]

[DianCharloValentine]

Firstly I created 4 pivot tables into 1 worksheet named OOTWeeklyTrendperPlatform, OOTWeeklyTrendperFailureMode, OverallWeeklyTrendperDereel, OverallWeeklyTrendperEngDataValue. These portion was completed successfully.

After that from each of these 4 pivot tables I wanted to create pivot chart. So there is 4 pivot tables and 4 pivot charts inside 1 worksheet.

My sequence of work is this way (table and chart name is for illustration purpose) table1 then chart1 then table2 then chart2 and so on. The problem is that after completed table1, chart1, and table2; I get an error when producing chart2 (or second chart correspond to table2). Please find shortened code below which shows only steps to create first 2 charts.

Please Login or Register  to view this content.

I get error: Method 'SetSourceData' of object '_chart' failed at part,

Please Login or Register  to view this content.