mattmalan6
New Member
- Joined
- Dec 20, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I want to have a drop down menu with stuff like "View Last Year," "View Last 6 Months" and then filter by each respective category. But I have no idea how to make a chart that dynamic. I've thought about using =filter() or a pivot table, but just wanted some feedback from you guys.