1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Sub CréationGraphique()
Dim Graph As Chart
dernierecolonne = Worksheets("Feuil1").Range("D2").End(xlToRight).Column - 3
'Pour chacune des colonnes de composés jusqu'à la dernière colonne remplie
For i = 4 To dernierecolonne + 3
Derniereligne = Worksheets("Feuil1").Cells(5, i).End(xlDown).Row
Set Graph = Charts.Add
With Graph
.Name = Worksheets("Feuil1").Cells(2, i).Value
.ChartType = xlXYScatterLinesNoMarkers
.SetSourceData Source:=Sheets("Feuil1").Range(Cells(5, 2), Cells(Derniereligne, i)), PlotBy:=xlColumns
.HasTitle = True
.ChartTitle.Text = Worksheets("Feuil1").Cells(2, i).Value
End With
Next
End Sub |
Partager