Series fill color method

Hi,
Using XL07 I'm trying to programmatically set the fill type to solid and the colour to a colorindex constant for a series in a chart.

I can select/activate specific charts and series, but can't work out how to modify the properties of the series.

I can't for the life of me piece together the method, properties and syntax for doing this.


Any assistance / advice welcome.

Thanks in advance - JB

Please Login or Register  to view this content.

See this recent thread for some more code
http://www.excelforum.com/excel-char...in-charts.html