Any chance you could go over linking shapes/text boxes when using slicers for the pivot tables? I was to create dashboard to outline min / avg / max expenses per unit for different types of apartment complexes. The filters would be by size group (# total units), age groups, location. Some locations don’t have all the same size groups or age groups. I’m stuck on how to structure the pulled out cells with it being so dynamic. Love your videos!
2026-07-12 16:11:03
1
Bert E :
I’ve pointed a text box at a pivot table cell before. You point it to a call outside the pivot table, then manually change the text box formula to a cell in the pivot table. I don’t think you can independently adjust text size though
2026-08-06 22:05:17
0
Aqua :
But anytime the file closes and u hit refresh, the format goes into default
2026-07-14 05:09:37
0
To see more videos from user @bigexcelenergy, please go to the Tikwm
homepage.