Dynamic restricted date range in a chart
I have a sheet with several years of client data on it. Using a second table using count if, I have created a breakdown of lead types. I assume that this second table is dynamic to the extent that it will update as I add data. But what I want is to create a chart that will dynamically show this information for the last 91 days. Is there a way to do this, short of creating a new table every time I want to see this chart?