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 usedBut when trying to adapt this for the 2nd (Area) series I tryBut 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 !!
For the line I used
ActiveChart.SeriesCollection(1).Format.Line.Weight = 2 ActiveChart.SeriesCollection(1).Border.Color = RGB(255, 255, 0)
ActiveChart.SeriesCollection(2).Format.Line.Weight = 1 ActiveChart.SeriesCollection(2).Border.Color = RGB(153, 204, 255)