The following example uses the **Activate** method to activate the chart sheet named Chart1, and then sets the interior color for series 1 in the chart to blue.

ChartSeries.vba Excel VBA class to get Chart Series data. The original version was created by John Walkenbach a loooong time ago. Actually, it is that old that I can’t remember when I have found it.

Howdy Folks,I have an Excel spreadsheet with several charts in it. Each chart has several data series plotted as xy scatter. I would like to change the ...