change color of column chart

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!
 
P

Peter T

Assuming you are talking about Excel 2007, try

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

Regards,
Peter R
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel VBA - Problem with Closing Print Preview 0
Extract RGB values for selected chart series 2
Setting the Colour of Individual Items within a Legend 6
Run select query from VBA code where criteria comes from a multi select ListBox 2
Color change for Column Chart 4
Two-tone color column chart 2
Access Combination Chart Types Access 2010 0

Top