Chart to move up or down with the rows of the pivot table?

Hello Guys,

I need one help.
I have the pivot table and the chart (based on some other table) below the Grand Total row.
Once I filter some data in the pivot, I get fewer number of rows in the pivot, but the graphs stays in the same place, while I would like to move it together with the Grand Total row of the pivot.

Is this possible or I have to move the graph manually all the time after change the number of rows in the pivot?
Please check the screenshots.
Thanks!
Stevan

Using the resize handles on the chart, hold ALT and drag the border to the relevant position. You'll notice that holding ALT snaps it to the cell border. The chart will now move with the cell when you filter.

I've not tested in a pivot table but should work the same

Thanks Radddogg,

Unfortunately, it seems it doesn't work with a pivot table.
Any other idea?
Thanks,
Stevan

Paste this in the vba module for the worksheet containing the pivot. Let me know if you need instructions how to do this.

There are two variables you may need to change highlighted in red below. 1, This is the column letter of any column that intersects your pivottable. 2, this is the name of your chart.

Please Login or Register  to view this content.

Regards Radddogg

I'm bit late But that you very much Radddogg! This worked.

Yay! Doing a little dance