Is the goal for the bar chart to be the view that shrinks/expands based upon the size of Sheet 1? Or are you looking for multiple visualizations to expand on this?
Have you investigated sheet swapping options? This might not work but if you have a small number of possible filters, the views could be fully swapped with this solution.
here is a good place to start with this: