Bonjour,
A tester.
Cdlt.
Option Explicit
Private Sub CommandButton1_Click()
Dim i As Long, j As Long
Application.ScreenUpdating = False
j = 40
Me.ChartObjects("Graphique 1").Activate
With ActiveChart.SeriesCollection(2)
For i = 1 To .Points.Count
.Points(i).Interior.Color = Me.Cells(j, 3).Interior.Color
j = j + 1
Next i
End With
j = 5
Me.ChartObjects("Graphique 2").Activate
With ActiveChart.SeriesCollection(2)
For i = 1 To .Points.Count
.Points(i).Interior.Color = Me.Cells(j, 3).Interior.Color
j = j + 1
Next i
End With
End Sub