1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
Sub coloriage17()
Dim i As Byte
Dim X
Dim j As Integer
For j = 1 To Worksheets("17").ChartObjects.Count
With Worksheets("17").ChartObjects(j).Chart.SeriesCollection(1)
X = .XValues
For i = 1 To UBound(X)
Select Case X(i)
Case "Culiseta annulata subochrea": .Points(i).Interior.Color = RGB(27, 149, 217)
Case "Aedes annulipes cantans": .Points(i).Interior.Color = RGB(134, 209, 228)
Case "Aedes caspius": .Points(i).Interior.Color = RGB(228, 135, 1)
Case "Aedes cinereus": .Points(i).Interior.Color = RGB(209, 223, 231)
Case "Aedes detritus coluzzii": .Points(i).Interior.Color = RGB(165, 188, 78)
Case "Aedes flavescens": .Points(i).Interior.Color = RGB(202, 202, 158)
Case "Aedes geniculatus": .Points(i).Interior.Color = RGB(240, 94, 39)
Case "Aedes punctor": .Points(i).Interior.Color = RGB(197, 246, 143)
Case "Aedes rusticus": .Points(i).Interior.Color = RGB(102, 147, 176)
Case "Aedes sticticus": .Points(i).Interior.Color = RGB(255, 247, 151)
Case "Aedes vexans": .Points(i).Interior.Color = RGB(228, 249, 160)
Case "Anopheles claviger": .Points(i).Interior.Color = RGB(6, 98, 176)
Case "Anopheles maculipennis": .Points(i).Interior.Color = RGB(231, 193, 116)
Case "Anopheles plumbeus": .Points(i).Interior.Color = RGB(189, 241, 230)
Case "Culex europaeus": .Points(i).Interior.Color = RGB(158, 152, 125)
Case "Culex hortensis": .Points(i).Interior.Color = RGB(237, 232, 198)
Case "Culex impudicus": .Points(i).Interior.Color = RGB(235, 152, 141)
Case "Culex modestus": .Points(i).Interior.Color = RGB(145, 201, 229)
Case "Culex pipiens": .Points(i).Interior.Color = RGB(197, 224, 93)
Case "Culex torrentium": .Points(i).Interior.Color = RGB(204, 51, 0)
Case "Culiseta fumipennis": .Points(i).Interior.Color = RGB(82, 212, 202)
Case "Culiseta litorea morsitans": .Points(i).Interior.Color = RGB(255, 213, 18)
Case "Culiseta longiareolata": .Points(i).Interior.Color = RGB(117, 176, 0)
End Select
Next i
End With
Next j
End Sub |
Partager