How to make chart dynamic based on table of data?

[mattmalan6]

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.

 

[Georgiboy]

I would go down the route of a pivot table with slicers. The slicers being your drop down lists.