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 CreerGraphiques()
Dim Sh As Worksheet, Co As ChartObject
ThisWorkbook.Activate
For Each Sh In Worksheets
With Sh
For Each Co In Sh.ChartObjects
Co.Delete
Next Co
Application.Goto .[IV1], True
Set Graph = .Shapes.AddChart(xlColumnClustered, .[F1].Left, .[A8].Top)
.[A1].Select
With .ChartObjects(1).Chart
.SeriesCollection.NewSeries
.SeriesCollection(1).Name = "Ventes type 1 2013"
.SeriesCollection(1).Values = "='[2013.xlsx]" & Sh.Name & "'!$B$2:$B$4"
.SeriesCollection.NewSeries
.SeriesCollection(2).Name = "Ventes type 1 2014"
.SeriesCollection(2).Values = "='" & Sh.Name & "'!$B$2:$B$4"
.SeriesCollection.NewSeries
.SeriesCollection(3).Name = "Ventes type 2 2013"
.SeriesCollection(3).Values = "='[2013.xlsx]" & Sh.Name & "'!$C$2:$C$4"
.SeriesCollection.NewSeries
.SeriesCollection(4).Name = "Ventes type 2 2014"
.SeriesCollection(4).Values = "='" & Sh.Name & "'!$C$2:$C$4"
.SeriesCollection(4).XValues = "='01 - janvier'!$A$2:$A$4"
End With
End With
Next Sh
End Sub |
Partager