I am wondering if it is possible to have a chart change based on another chart being selected. For example I have two container objects with 4 pivot table charts. One container has sales YTD sales information by Customer Brand, Category Brand, Customer Category, and Attribute Brand. The other container has YTD sales variance by Customer Brand, Category Brand, Customer Category, and Attribute Brand. I want the YTD sales variance chart to change when the YTD sales chart is changed. For example I if a user selects Category Brand in the container box that has YTD sales I want the container below that has YTD variance to be selected. Currently a user has to manually select both. Would love to know if this is a possibility.
