I'm in deep trouble 
I have created a dashboard that has a lot of pivot charts, these charts are controlled by Slicers.
I want the chart label in "Rotate text 270", which I set manually once but when I apply the slicer all the labels go back to horizontal, could you please guide me on how I can keep them in rotated text format.
I am Okay to apply VBA for this.
Also please guide how I can apply/remove the primary vertical major axis and primary major gridlines using VBA
I have created a dashboard that has a lot of pivot charts, these charts are controlled by Slicers.
I want the chart label in "Rotate text 270", which I set manually once but when I apply the slicer all the labels go back to horizontal, could you please guide me on how I can keep them in rotated text format.
I am Okay to apply VBA for this.
Also please guide how I can apply/remove the primary vertical major axis and primary major gridlines using VBA
