VBA Chart series set Color Fill to "Automatic" <p>I want to highlight some series in my stack chart - this is I have implemented. But the chart is dynamic, so when I change selection I need to highlight other series. But what was highlighted previously remains highlighted.</p> <p>I am thinking to tun a cycle through all series and assign Fill Color of the series as "Automatic" each time when I change the source. Then I could highlight the needed series.</p> <p>I have have found 2 options to sent the color using properties</p> <p><strong>.Interior.Color</strong> </p> <ul> <li>OR</li> </ul> <p><strong>.Format.Fill.ForeColor.SchemeColor</strong></p> <p>But there I used RGB color model to set a color.</p> <p>How can I come back to <strong>"Automatic"</strong> color, that is <strong>default color</strong> in my chart template. What value should I assign to the properties above?</p> <p>Thanks!</p>