I have a pivot table that has several months worth of data. I have several pivot charts based on that data, and a date slicer linked to multiple charts to select the date range. What I would like to add is a button that lets me automatically select the most recent 7 days of data. Is it possible to have a macro that will update my slicer filter?