How to change an area chart series type

[NatetheGreat]

I have a chart with three data series plotted on it. Series1 is a line, Series2 and Series3 are area chart series types. I have figured out how to change the forma/color of the line, but it is proving to be quite difficult for the area series.

For the line I used

ActiveChart.SeriesCollection(1).Format.Line.Weight = 2
    ActiveChart.SeriesCollection(1).Border.Color = RGB(255, 255, 0)

But when trying to adapt this for the 2nd (Area) series I try

 ActiveChart.SeriesCollection(2).Format.Line.Weight = 1
    ActiveChart.SeriesCollection(2).Border.Color = RGB(153, 204, 255)

But what this does is just colour the lines around he area rather than the entire area. I cant even begin to think how I'm going to set the transparency level !!

Please assist.

 

[pgc01]

Hi Nate

Try:

ActiveChart.SeriesCollection(2).Format.Fill.ForeColor.RGB = RGB(153, 204, 255)