Sub CouleurChoix()
Dim ObjPoint As Point
Dim i As Integer
Dim TabPoints As Variant
ActiveSheet.ChartObjects("Graphique 3").Activate
With ActiveChart
TabPoints = ActiveChart.SeriesCollection(1).XValues
i = 0
For Each ObjPoint In ActiveChart.SeriesCollection(1).Points
i = i + 1
Select Case True
'Case InStr(ObjPoint.DataLabel.Caption, "Choix1") <> 0
Case InStr(TabPoints(i), "Choix1") <> 0
'ObjPoint.Format.Fill.ForeColor.ObjectThemeColor = msoThemeColorAccent6
'ObjPoint.Format.Fill.ForeColor.RGB = RGB(255, 255, 0)
ObjPoint.Format.Fill.ForeColor.RGB = Range("COULEUR_1").Interior.Color
Case InStr(TabPoints(i), "Choix2") <> 0
ObjPoint.Format.Fill.ForeColor.RGB = Range("COULEUR_2").Interior.Color
Case InStr(TabPoints(i), "Choix3") <> 0
ObjPoint.Format.Fill.ForeColor.RGB = Range("COULEUR_3").Interior.Color
End Select
Next ObjPoint
End With
End Sub