This sample found in VBA help sets the transparency to 50%.

With Worksheets(1).Shapes(3).Shadow
.Visible = True
.ForeColor.RGB = RGB(255, 0, 0)
.Transparency = 0.5
End With


"gottahavit" wrote:

I am using VB to add multiple series in a scatterplot. I want the markers to
be 50% transparent, but I cannot seem to figure out how.
Can anyone help?

Thanks.