I’m trying to set colours in a vba graphing macro. I want the colour for the first two series to be the same, then the next two series to be the next colour and so on.

I initially tried to record the colour from the first of each pair and then apply it to the next, but it seems like when vba creates a series, it doesn’t actually save the colour in the properties – while the series will appear as their assigned colours in the palette, if you try to pull their colour or colourindex values they’re all set to white (-1 using markerforegroundcolor and 1 using markerforegroundcolourindex), so when I tried to use them to set the other series it would just make them
invisible.

The next solution here would be to set them using colourindex values, but when I try to set them using markerforegroundcolorindex = 3 or the like, it returns only the eyemelting base rgb of the colour in the palette, instead of the actual colour with intensities and brightness modifiers.

Is there a way to either pull the full parameters of a colour from the palette, or to somehow pull the colour from an automatically created series?

And/or if palletes have default intensity and brightness modifiers, where can I find that information/get vba to give it to me so I can apply it to each marker?

As a final note, I know I can just create a colour palette with everything doubled, which is what I’m using for now, but a) it’d be nice to still get 6 distinct colors instead of just three before it starts looping, and b) I’m trying to make this macro as userfriendly as possible for my co-workers