As can be seen on the attached image, i have expanded the Pivot Table down to view a more broken down view of the data.
With the current view, is there VBA that i can add to make a more visual difference between the 1200 data and the 1050 data, so the 1200 or 1050 columns vary in color?
If i change the 'Vary Colors by Point', each column is a different color, where i want all the 1200 section columns one color, and the 1050 section another color.
Is this possible?
Bookmarks