Sheet Swapping for Bar Chart

This short & neat post describes an interesting solution on how to do sheet swapping for bar chart.

Scenario:  Sheet swapping doesn’t work well with bar chart. One of the worksheets doesn’t automatically reduce in size when the parameter value is not selected.

Fortunately, there’s a work-around solution for this problem.

Solution:  Insert a ‘NULL’ calculated field in the Rows pane of both worksheets. This should fix the problem and sheet swapping can be used with bar charts again.