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
| Sub Actualiser2()
Dim PlageX As Range, PlageY As Range, C As Range, I As Integer
Dim Série As Series, Res As Long
With Sheets("Feuil4")
With .ChartObjects(1).Chart
For I = .SeriesCollection.Count To 1 Step -1
.SeriesCollection(I).Delete
Next I
End With
For Each C In .Range("C2", .Cells(.Rows.Count, 3).End(xlUp))
If C <> "" Then
If C <> Res Then
Res = C.Value
.[G1].FormulaArray = "=Match(True," & C.Resize(1000).Address & "= """", 0)-1"
Set PlageY = C.Offset(, -2).Resize(.[G1])
Set PlageX = PlageY.Offset(, 1)
.[G1] = ""
With .ChartObjects(1).Chart
Set Série = .SeriesCollection.NewSeries
Série.XValues = PlageX
Série.Values = PlageY
End With
End If
Else
Res = 0
End If
Next C
End With
End Sub |
Partager