3 Replies Latest reply on Jun 1, 2017 6:41 PM by Chris McClellan

    How do you dynamically resize bubble graphs when switching between views with a parameter?

    Stephen Jay

      There are a bunch of neat tutorials online that demonstrate how to toggle between views with a parameter.

      This works by dynamically resizing the inactive worksheets to a very small size.

      I cannot get this to work with bubble charts though.

       

      See the attached workbook example. Toggling between two crosstabsworks beautifully.

      When trying to toggle between two bubble graphs, the layout does not work in the same manner that the crosstabs.

       

      Any ideas? I've been uselessly been trying to get this to work for hours.