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


"Robin" <(E-Mail Removed)> wrote in message
news:6FCEEC44-5C94-4BBB-B241-(E-Mail Removed)...
> 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!
>

Perfect, thanks Peter.

"Peter T" wrote:

> Assuming you are talking about Excel 2007, try
>
> mySrs.Format.Fill.ForeColor.RGB = RGB(186, 7, 0)
>
> Regards,
> Peter R
>
>
> "Robin" <(E-Mail Removed)> wrote in message
> news:6FCEEC44-5C94-4BBB-B241-(E-Mail Removed)...
> > 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!
> >
>
>
>