I have a requirement that requires my users to add/remove additional dimensions to the existing Pivot Table. Since, I need the existing dimensions to be displayed along with the ones the users choose, I am using a Macro to incorporate that functionality. When I add dimensions:
1. The dimension column label background inherits the chart properties background color (which is required).
2. However, the dimension data also inherits the chart properties which makes the background color white. I need to make this transparent like the rest of the pivot table. (which I had initially done through custom format cell)
Can this be done using a macro or is there a workaround?
