title: Column border color changed when I changed the color palette
body: <p>would like to ask what VBA code could help to not make my column border disappear when I change the color of my column bars from the color palette?
  As shown in Picture 1 there's borders around the column chart but when I changed the color of my column chart (Picture 2) the borders disappeared.</p>
  <p><a href="https://i.stack.imgur.com/1lDgS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1lDgS.png" alt="Picture 1" /></a></p>
  <p><a href="https://i.stack.imgur.com/NDpyw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NDpyw.png" alt="Picture 2" /></a></p>
  <p>[Edits]
  This is the code I tried to insert the borders:</p>
  <pre><code>For i = 1 To cht.SeriesCollection.Count
      With cht.SeriesCollection(i)
          .Format.Line.ForeColor.RGB = RGB(0, 0, 0)
          .Format.Line.Weight = 0.5
      End With
  Next i
  </code></pre>