Sub Couleurs_Type_Usage()
Dim Wsh As Worksheet, C As Range, Pt As Point, TbC, Tb, i As Long
Set Wsh = ActiveSheet
'Tableau du type d'usage
Tb = Wsh.[$E$2:$E$26].Value
'Tableau des couleurs en fonction du type d'usage
ReDim TbC(1 To Wsh.[Couleurs].Count)
i = 0
For Each C In Wsh.[Couleurs].Cells
i = i + 1
TbC(i) = C.Interior.color
Next
i = 0
For Each Pt In Wsh.ChartObjects(1).Chart.FullSeriesCollection(1).Points
i = i + 1
Pt.Format.Fill.ForeColor.RGB = TbC(Tb(i, 1))
Next
End Sub