I have two containers in a sheet, each of them has three tabs. The upper container has three bar charts corresponding to each tab, and the lower container has three pivot tables corresponding to each tab. What I want to do is this: when clicking on the first tab in the upper container, the first tab in the lower container is activated; when clicking on the second tab in the upper container, the second tab in the lower container is activated; and so on.
It seems I couldn't add an action when clicking on a chart in QV11. Is there any other way I could link the tabs in two containers?
Maybe you could change the layout concept and use the 'grid' option of the container.
Create 3 containers, each with one bar chart and one pivot table, and use the 'grid' option to show both at the same time. Then, create another container, and insert the 3 previously create containers into the outer container.
