HI,
I have an application wherein I have tried to make the charts active on a selection based on the the click of a button meaning the selected year gets associated on the chart only when apply button is clicked which in turn runs a macro to attach or detach the charts based on the button click.This functionality works fine on a straight table but on the chart it fails though the hold button is clicked the selection gets applied on chart but the chart stays on detached phase which is quite contradictory, so can anyone check on this and provide a solution.
Also, if we happen to click on hold make a selection in first subtab(Loss) and then move onto the other subtabs for the first time the straight table also shows the associative selection even when in detached phase just like the above case.
I am attaching a sample application for reference