Excel Camera/Linked Picture of dynamic Pivot - picture size is not adjusting

Question

Tried a few things - I need a linked picture to the columns in a dynamically filtered pivot table. I only need to show the first 3 column labels - where the image is longer or shorted based on pivot, but font of the text appears the same as the source.

1 - highlight entire pivot table A1-M15(down arrow on first row/column of pivot rows) - I pasted the linked picture. - I increased the size of the pivot by a few rows - it showed the original $A$1:$M$15 rather than $A$1:$M$18 - ultimately I would crop out the filters and data (if it worked)

2 - used a named range with offset starting with the top filter cell of the pivot - myImage=offset(sheet.$A$1,0,0,counta(sheet.$A:$A)+2,13) - copied entire pivot as in #1 and then clicked on the image and used named range in formula =myImage - I increased the data by a few rows by changing filters - The linked picture showed all the data A1-M18 in the original sized picture (by decreasing the size of the picture to fit the original size)

3 - used a named range with offset starting with the top row of the pivot - myImage=offset(sheet.$A$6,0,0,counta(sheet.$A$6:$A$1000),3) - I highlighted A6-C13 and inserted the linked picture - increased the rows by a few and got same results as with #2

I also repeated each of these scenarios using all combinations of "Lock Aspect Ratio" and "Relative to original picture size" with same results.

What I want is for the picture to get longer and shorted to support the data in the range, where in all pictures, the font appears to be the same as the source.

Any help would be greatly appreciated.