change color of column chart

  • Thread starter Thread starter Robin
  • Start date Start date
R

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!
 
Assuming you are talking about Excel 2007, try

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

Regards,
Peter R
 
Back
Top