Change color of data points in a chart in excel using VBA

00:40 Method 1: Change data point color based on categories 06:34 Method 2: Change data point color based on numbers Sub color_dots() Dim s As Series Dim i As Integer Set s = (1) For i = 1 To If Cells(i 1, 3) = “A“ Then (i). = RGB(255, 80, 80) If Cells(i 1, 3) = “B“ Then (i). = RGB(255, 153, 0) If Cells(i 1, 3) = “C“ Then (i). = RGB(0, 128, 128) Next i End Sub ---------------------------------------------------------------------------------------------------------------- Sub color_dots() Dim s As Series Dim i As Integer Set s = (1) For i = 1 To (i). = Cells(i 1, 4