title: Modify Marker Transparency with Excel VBA
body: <p>Lets say I have the table below and I want to make a scatter plot of it.</p>
  
  <pre><code>X    Y      Weight
  
  1    0.5    12
  2    0.1    23
  3    0.2    36
  4    0.5    27
  1    0.2    4
  </code></pre>
  
  <p>I am looking for a way to set the transparency of marker based on values in a column so that each point's marker has its individual transparency level which might not be the same as the other points. The reason I want this is that the weight of the points is not equal.</p>
  
  <p>One solution would be to create further number of points (Weight - 1) manually and plot them all with an appropriate transparency level. Another solution would be to set the marker transparency level for each point manually. However, none of these are logical as the number of the points is really large!</p>
  
  <p>I have tried the below with VBA but no luck with it.</p>
  
  <pre><code>Sub TransparencyModifier()
  '
  ' TransparencyModifier Macro
  '
  
  '
  
  Dim i as Integer
  For i = 1 to 5
      ActiveChart.SeriesCollection(1).Select
      ActiveChart.SeriesCollection(1).Points(i).Select
      With Selection.Format.Fill
          .Transparency = Cells(i+1,3).Value/100
      End With
  Next i
  End Sub
  </code></pre>
  
  <p>Any help is appreciated</p>