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
|
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection.NewSeries
'serie1 FPC
ActiveChart.SeriesCollection(1).Values = _
"=(consolidation!R" & NumeroLigne & "C5,consolidation!R" & NumeroLigne & "C9,consolidation!R" & NumeroLigne & "C13)"
ActiveChart.SeriesCollection(1).Name = "=consolidation!R4C5"
ActiveChart.SeriesCollection(1).XValues = _
"=(consolidation!R3C5,consolidation!R3C9,consolidation!R3C13)"
'serie dépenses FPC
ActiveChart.SeriesCollection(2).Values = _
"=(consolidation!R" & NumeroLigne & "C7,consolidation!R" & NumeroLigne & "C11,consolidation!R" & NumeroLigne & "C15)"
ActiveChart.SeriesCollection(2).Name = "=consolidation!R4C7"
ActiveChart.SeriesCollection(2).XValues = _
"=(consolidation!R3C7,consolidation!R3C11,consolidation!R3C15)"
'serie3 collecte pro
ActiveChart.SeriesCollection(3).Values = _
"=(consolidation!R" & NumeroLigne & "C6,consolidation!R" & NumeroLigne & "C10,consolidation!R" & NumeroLigne & "C14)"
ActiveChart.SeriesCollection(3).Name = "=consolidation!R4C6"
ActiveChart.SeriesCollection(3).XValues = _
"=(consolidation!R3C6,consolidation!R3C10,consolidation!R3C14)"
'serie4 Dépenses pro
ActiveChart.SeriesCollection(4).Values = _
"=(consolidation!R" & NumeroLigne & "C8,consolidation!R" & NumeroLigne & "C12,consolidation!R" & NumeroLigne & "C16)"
ActiveChart.SeriesCollection(4).Name = "=consolidation!R4C8"
ActiveChart.SeriesCollection(4).XValues = _
"=(consolidation!R3C8,consolidation!R3C12,consolidation!R3C16)" |
Partager