Hi,

I'm working on a stacked column charts where I want to be able to set the color and pattern of each segment using VBA. Right now, I can choose the pattern I want using 
Please Login or Register  to view this content.
(J cycles through points in the series and K cycles through patterns based on an arraylist). I can't, however, change the color of the pattern- I know I must be missing something here but I'm not sure what it is based on the VBA docs from Microsoft. So far I have tried using 
Please Login or Register  to view this content.
(which works when setting a solid fill but not for my patterns) and 
Please Login or Register  to view this content.
or 
Please Login or Register  to view this content.
which don't seem to be doing anything.

For more context, I'm setting the color to match certain cells like so 
Please Login or Register  to view this content.
.

Any help is appreciated!