Apply RGB color into a MSGraph

[Alex St-Pierre]

Hi,
I use the following code but the line ".Border.ColorIndex = RGB(225, 76,
38)" doesn't give the right color. It returns a standard windows color that
is similar but not the same. I have add the color into the windows custom
color (MSGraph/Tools/Options [Color] at Cells(6,1) = right custom color but I
can't access this color using the 56 standards ColorIndex. Even if there's 7
rows X 8 colors per row = 56. Any idea?
Thank you!
Alex
With oChart2.SeriesCollection(i)
.Border.LineStyle = xlContinuous
.Border.Weight = xlMedium
.Border.Color = RGB(225, 76, 38) 'doesn't work
.Interior.Color = RGB(225, 76, 38) 'doesn't work
.HasDataLabels = False
End With

 

[Jonathan West]

Hi,
I use the following code but the line ".Border.ColorIndex = RGB(225, 76,
38)" doesn't give the right color. It returns a standard windows color
that
is similar but not the same. I have add the color into the windows custom
color (MSGraph/Tools/Options [Color] at Cells(6,1) = right custom color
but I
can't access this color using the 56 standards ColorIndex. Even if there's
7
rows X 8 colors per row = 56. Any idea?
Thank you!
Alex
With oChart2.SeriesCollection(i)
.Border.LineStyle = xlContinuous
.Border.Weight = xlMedium
.Border.Color = RGB(225, 76, 38) 'doesn't work
.Interior.Color = RGB(225, 76, 38) 'doesn't work
.HasDataLabels = False
End With

MSGraph has a long-standing bug that means that the color palette cannot be
modified through the automation interface.

I think you're out of luck.