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.

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.

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

"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.

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/ChartsH...omMarkers.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"gottahavit" wrote in message
...
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.

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

"Andy Pope" wrote:

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/ChartsH...omMarkers.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"gottahavit" wrote in message
...
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.

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"gotahavit" wrote in message
...
I do have xl2007, but I can't seem to find a method to apply it in VB.
Thanks for your help.

"Andy Pope" wrote:

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/ChartsH...omMarkers.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"gottahavit" wrote in message
...
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.