I have a pivot table with dates in column A (properly formatted as dates) and a quantity x in column B. The dates go back to 2016, but I want to create a graph with the data from 2021-now.
This means I want to filter the dates like it is usually possible, for example in the data source (another sheet). See this image: https://1.bp.blogspot.com/-UbfD2YVaZ-Q/XeAndgBX_mI/AAAAAAAABLw/FglgsyX3sY4inF099WeMYg9OOGHfRw_9QCNcBGAsYHQ/s1600/Autofilter%2Bwith%2Bmonths%2Band%2Byears.png
In the pivot table, I can only filter by selecting day for day.
How can I filter dates as dates in the pivot table? Alternatively, how can I change the data range of the graph built from the pivot table? This doesn’t work for the graph created from pivot table: How to adjust a x and y axis ranges on a chart created in Calc