PDA

View Full Version : column chart seriescollection transparency



werafa
11-17-2012, 12:56 PM
hi all,
I am building a column chart, and am trying to set the chart series to 33% transparency, and after many hours have cracked it (I had just started to write this as a question.

since there was no help on the web, I'll post this as a 'fix'

Setting transparency on its own didn't work - unless I did it manually first
The answer was to set the fill to solid.

hope this helps someone
Werafa

Sub FormatTransparent(chartBit As Object)
'format chart elements as transparent
With chartBit
.Border.LineStyle = xlSolid
.Border.Color = .Format.Fill.ForeColor.RGB
.Format.Fill.Solid
.Format.Fill.Transparency = 0.33

End With

End Sub