I am making a dashboard in excel with multiple pivot tables and slicers and would like to know how the tables and graphs can automatically extend without overlapping. Moreover I'm making charts/graphs with no default settings which I would like to save as templates but I don't know how to make them remain or extend when selecting other things in the slicers.
Solved by C. H. in 12 mins