5 Replies Latest reply on Aug 24, 2016 12:30 AM by Rahul Verma

    Conditionally changing the bar chart color based on selection of value in another bar chart

    Sahithya Reddy

      Hi,

       

      I am having 2 worksheets. One is having Categorywise sales shown in bar chart and one is having subcategorywise sales shown in bar chart. Its a many-to-many relation.

      Each category is having different color. Each subcategory is having different color. I need is when I select category name, then all related fields should be highlighted in subcategory chart with same color of category which I have chosen. Suppose when I click category1 which is in yellow then related subcategories should be highlighted in Subcategory sheet with Yellow color .