Macro for Enabling or Disabling Expression dynamically
I have a category or component table which I have to extract from DB so the data which will consist uder Category field will be dynamic . Now for each category I am creating expression and label.So there are already 2 expression present in the pivot chart which will be by default and now based on the Category or component field selection we have to enable or disable expression and have to show selected component label for the corresponding expression. I was trying that problem through macro. May be it is possible through macro . Could anyone check and let me help.Please check the attached application.