I am trying to change the colors for my chart series MARKERS if they have a pattern.
I have no issues with creating the correct chart but I cannot change the pattern color, it seems to be always “blue”. I have tried the general series settings:
With SeriesCollection(mySeries) .MarkerStyle = 7 .MarkerSize = 3 .format.Fill.ForeColor.RGB = RGB(22, 22, 22) .format.Fill.BackColor.RGB = RGB(22, 22, 22) .format.Fill.Patterned msoPatternNarrowHorizontal End with
This does not work. When I set the pattern style the markers are being formatted back to their “blue” color.
I have also tried looping through the points to change them one by one but it does not work either.
For Each pt In mychart.SeriesCollection(mySeries).Points pt.format.Fill.ForeColor.RGB = RGB(22, 22, 22) pt.format.Fill.BackColor.RGB = RGB(22, 22, 22) pt.format.Fill.Patterned msoPatternNarrowHorizontal Next pt
As soon as I set the pattern it changes color. If I change the color AFTER setting pattern, the pattern disappears.
Any ideas how to set the correct for patterned markers?