Using Excel 2010 and VBA, I experience a problem when I try to set the transparency of the fill of circular data points of a seriescollection in an XYScatter chart. As soon as the relevant code line is executed, the fill colour changes to olive green regardless of the colour it has been originally. I tried the same basic code line in a line chart and it operated correctly. I also tried the code in a completely new chart and the problem persisted.

The relevant code line is
ActiveChart.SeriesCollection(1).Format.Fill.Transparency = 0.5
Any help?
Does anybody know whether the same problem occurs when using Excel 2013?

Thanks
itbcvdw