francklouis
New Member
- Joined
- Apr 13, 2020
- Messages
- 11
- Office Version
- 2007
- Platform
- Windows
Problelem: have generated a 4 series bar chart using vba, but series 1 is hidden behind series 2, which is much taller. I have Excel 2007.
Question : I would like to make series (2) 50% transparent to make series (1) behind it visible. I have tried the following code but it does not have any effect. I cant work out the error??
Here is the code I have:
With Cht_2.Chart.SeriesCollection(2)
.Format.Fill.Solid
.Format.Fill.Transparency = 0.5
.Interior.Color = RGB(255, 0, 0)
End With
Question : I would like to make series (2) 50% transparent to make series (1) behind it visible. I have tried the following code but it does not have any effect. I cant work out the error??
Here is the code I have:
With Cht_2.Chart.SeriesCollection(2)
.Format.Fill.Solid
.Format.Fill.Transparency = 0.5
.Interior.Color = RGB(255, 0, 0)
End With
