So I'm working with a big data set, around 50k lines and I'm using pivot charts to visually display our data.

However I am running into issues with overlapping pivot tables so I'm trying to find the best way to format my tables so they won't run into any overlap issues.

To begin with, I am not 100% sure how many rows/columns I need as the list gets pretty expansive when certain slicer filters are selected so I can't format them correctly that way.

Any ideas on good ways to handle formatting pivot tables so that when they expand they don't overlap? I'll have probably around 15-30 pivot charts/tables.

Is it a good idea to put the big ones on separate sheets then hide them?