View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default change color of column chart

Assuming you are talking about Excel 2007, try

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

Regards,
Peter R


"Robin" wrote in message
...
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!