Chart is resizing when expand the Pivot Table

[Spiru]

Hi everyone,

I have a chart that is linked to the grand total of a pivot table and the issue is that the chart is resizing when I expand the pivot table. Is there a way to to lock the chart to this grand total?

I have tried this, but it didn't work.

1. Select all cells on the sheet- Right click Format Cells- Under Protection- check Locked option

2. Right click Chart- select Format Chart Area- under Size&Properties option- check Lock aspect ratio- select Don't move or size with cells

Thank you,

 

[Spiru]

anyone?