Pivot table and Pivot Chart - Run time error 5

Hi,

I have recorded a macro for pivot table with chart and if i run for 2nd time .. a error come as run time 5

Due to change in dynamic reference... please help out in modifying the vba code for the same,.

Please help asap.

Try something like this...

Please Login or Register  to view this content.

Actually, instead of scaling the width and height, you can specify the exact location and size of the chart. For example, to position the chart so that the top left cell is F4, and set its width and height to 525 and 275, respectively, try...

Please Login or Register  to view this content.