I have a report with 7 pivots down the left hand side of my sheet. They also each have a chart to the right of them.

The issue is that when the user changes the timeline slicer to change the month view of the data, some of the pivots will have a different number of rows in the new month. The pivots may overlap of there could be a lot of blank rows between them. I could leave enough room for the maximum possible number of rows any pivot could have, but the report would look bad.

Is there a setting/trick that allows the pivots to move so that they don't overlap and always have say, 3 rows, between each pivot.

I could probably achieve this with VBA but I want to check I am not missing something easier and quicker.

Thanks

Andrew