Is There A Way To Move An Excel Pivot Chart

[Tidy]

Good Morning,
I have a quick question. Is there anyway to move an "Excel Pivot Chart" (The actual chart) around using VBA in access. I'm trying to mount the chart on a certain position of my spreadsheet but with no luck. I can't find any code that will set the charts location. If anyone knows if this is possible or not please let me know.

 

[Tidy]

SMH, are my questions always unanswerable LOL.

 

[Tidy]

I found the answer after hours of searching the web and playing with the code. If anyone else has run into this problem here is the answer.

    'Set PIVOT CHART Location by Height/Width and Left/Top
    objxlBook.ActiveSheet.ChartObjects("Chart 1").Left = Cells(11, 2).Left
    objxlBook.ActiveSheet.ChartObjects("Chart 1").Top = Cells(11, 2).Top
    objxlBook.ActiveSheet.ChartObjects("Chart 1").Height = Range("B11:B35").Height
    objxlBook.ActiveSheet.ChartObjects("Chart 1").Width = Range("B11:J11").Width