I'll attach a demo spreadsheet where I tried to get a dynamically resizing chart
by using two database ranges "Source" and "Target" where the latter is the
target range of the other's filter descriptor (Option "Copy Output").
It works perfectly while the target range grows. The more values are matched by
the filter, the more values are drawn into the chart. Database range "Target"
adjusts to the new size and so does the chart. This desired feature seems to
rely on option "Insert and delete cells" applied to the target range.
However, when we apply a filter that matches fewer rows than the previous one
the size does not adjust.
If this feature would work in both directions, it could provide a good
work-around for some of the more tricky issues.