I'm not sure but I believe this won't be possible. To activate objects per actions is already difficult if this are single-objects and there are none actions-logic to access an object within a container. I think you will need a compromise between layout and usability.
The only other workaround is if you create something that looks like a container, but is actually just text objects with actions attached to change a variable, then the charts visible depending on the variable.
You could then also set the desired variable when the sheet is activated.