i am working on the container object. i have 2 container objects each having 6 objects in it. The first container contains all Gauge charts and 2nd container contains 6 bar charts. if i select any one of the gauge chart in first container, the corresponding bar chart in the 2nd container should be activated.
For ex: if i select 3rd object in the 1st container, the corresponding bar chart in the 2nd container should be activated and vice versa.
The objects in the first container is showing aggregate information(using gauge chart) and objects in the 2nd container is showing trend (using bar chart).
You need to copy paste it as many tabs as you have - I did it here for 3 tabs/objects in 2 containers. The logic is the same.
It is not exactly what you want - to activate second container's corresponding tab when clicking on another in the first container (I think there is no way to do it like this or maybe there is, but the macro code would be more complicated) ;
instead it has 3 (in you case they will be six - you can make them quite small and nice looking) buttons to trigger corresponding Tabs in both containers.
Btw, I think it would be much better for the layout to do it in this way, and not have name on tabs of each container that will make the eyes tired. Just name the containers Aggregate / Trend and then name the six buttons - you'll have only 8 names (versus 14 in the case you name the Tabs as well.)