Chart Series colour with VBA

[Peter Davison]

I have an XYScatter chart and all I want to do is simply colour the points after new data has gone in.
I found the below on this site and only changed the name of the points series to Cluster 1 and 2 (before it had (1) and (2)
The macro runs but nothing changes from existing.
What am I doing wrong?

Any help would be appreciated.

Private Sub CommandButton2_Click()

ActiveSheet.ChartObjects("Chart 1").Activate

ActiveChart.SeriesCollection("Cluster 1").Interior.Color = RGB(0, 255, 255)
ActiveChart.SeriesCollection("Cluster 2").Interior.Color = RGB(255, 0, 0)


End Sub

 

[Zot]

Try

ActiveChart.SeriesCollection("Cluster 2").Format.Fill.ForeColor.RGB = RGB(255, 0, 0)

 

[Peter Davison]

Thankyou for your help, really appreciate it.

 

[Zot]

Thankyou for your help, really appreciate it.

You're welcomed