How to create a histogram that updates when I filter the input ran

[Paul Trelc]

I want to be able to run an advance filter on an input range and have a
histogram that automatically updates to reflect the filtered range. This
works on regular Excel charts. I am using the Frequency function to create
the histogram.
Help?