I'm new to loops and am looking for a way to loop through pivot table series to change their colors. I am able to do it statically with the following code:
In this example I am changing series 1 to Brown, series 2 to blue, series 3 to green, and series 4 to orange. I need this pattern to repeat every 4 series. But it needs to be dynamic since the number of series will change each time. There could be 12 series, 20, 24, etc..Please Login or Register to view this content.
Any help is appreciated!
Thanks!
Bookmarks