I'm attempting to make a macro that would change the appearance of chart series. I need to change the series to be the same color in triplicates (with different markers for each 3), so a macro I found here for modifying ALL series doesn't work here.
Here are my questions:
1) Can the marker style be set as one style for series 1,4,7,10,13,16,...; a second style for series 2,5,11,14,17... and a third style for series 3,6,12,15,18... and how? So there would only be 3 parts to be changed if a change in the marker style was needed. I now sort of came up with a simple working core that I think I will use to expand. I at least figured out the 'working in sets of 3' part, but not how to specify which series to edit instead of a range (for the marker styles).
2 a) Is there a way to make the marker fill color check what color is set as the series line color and set the same marker fill color automatically?
2 b) (Depending on the approach) Is it possible to make a reference that would work from another macro?
3) There will be an error if there aren't as many series as my macro is trying to edit. Is the only prevention adding On error (do something)-statements before every new (For X = a to b) "block"?
This is the stuff I'm thinking of expanding on:
Bookmarks