Marker Transparency

[gottahavit]

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.

 

[JLGWhiz]

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

 

[JLGWhiz]

However, there does not seem to be a facility in VBA to set the transparency
of a marker.

 

[Andy Pope]

Hi,

Transparency of markers is only available in xl2007.

For previous versions you could use a custom marker based on an autoshape
which can be transparent.
This explains how to use custom markers. You can use the macro recorder to
generate starting code.
http://peltiertech.com/Excel/ChartsHowTo/CustomMarkers.html

Cheers
Andy

 

[gotahavit]

I do have xl2007, but I can't seem to find a method to apply it in VB.
Thanks for your help.

 

[Andy Pope]

Hi,

Big see thru red circles for series 1.

Dim objSeries As Series

Set objSeries = ActiveChart.SeriesCollection(1)
With objSeries
.MarkerSize = 30
.MarkerStyle = xlMarkerStyleCircle
.MarkerBackgroundColor = RGB(255, 0, 0)
.Format.Fill.Transparency = 0.5 ' 50%
End With

Cheers
Andy