title: How to change chart colors in VBA
body: <p>I have to change the colors of a pie chart in VBA. I 'managed' to change the font color, which is not what I wanted, this way:</p>
  
  <pre><code>ActiveChart.Legend.LegendEntries(1).Border.ColorIndex = 6
  </code></pre>
  
  <p>I want to change the color of the actual piece of pie.
  I also have to set specific colors, which are part of the standard palette. The 6 above gives me a flashy yellow but I want the colors highlighted here </p>
  
  <p><img src="https://i.stack.imgur.com/DGQgy.png" alt="enter image description here"></p>