change color of column chart

[Robin]

Hi
I am trying to change the FILL RGB color of a column chart and I am
struggling to find the correct syntax. For the line in a scatter graph, its
mySrs.Format.Line.ForeColor.RGB = RGB(186, 7, 0)
but what is the equivalent for a column chart?
Thanks!

 

[Peter T]

Assuming you are talking about Excel 2007, try

mySrs.Format.Fill.ForeColor.RGB = RGB(186, 7, 0)

Regards,
Peter R

 

[Robin]

Perfect, thanks Peter.

Assuming you are talking about Excel 2007, try

mySrs.Format.Fill.ForeColor.RGB = RGB(186, 7, 0)

Regards,
Peter R