Sheets("Graphiques").ChartObjects("Graphique " & i).Activate
Sheets("Graphiques").ChartObjects("Graphique " & i).Activate ActiveChart.SeriesCollection(1).Values = "=TAB!R" & j & "C7:R" & j + 11 & "C7" ActiveChart.SeriesCollection(1).Name = "=TAB!R1C7" ActiveChart.SeriesCollection(2).Values = "=TAB!R" & j & "C5:R" & j + 11 & "C5" ActiveChart.SeriesCollection(2).Name = "=TAB!R1C5" ActiveChart.SeriesCollection(3).Values = "=TAB!R" & j & "C3:R" & j + 11 & "C3" ActiveChart.SeriesCollection(3).Name = "=TAB!R1C3" ActiveChart.SeriesCollection(3).ApplyDataLabels AutoText:=True, ShowValue:=False ActiveChart.SeriesCollection(3).Points(mois).ApplyDataLabels AutoText:=True, ShowValue:=True With ActiveChart.SeriesCollection(3).DataLabels.Border .Weight = 1 .LineStyle = -4105 End With ActiveChart.SeriesCollection(3).DataLabels.Shadow = True ActiveChart.SeriesCollection(3).DataLabels.Interior.ColorIndex = -4105 With ActiveChart.SeriesCollection(3).DataLabels.Font .Name = "Arial" .FontStyle = "Gras italique" .Size = 10 .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic .Background = xlAutomatic End With i = i + 1 j = j + 12 Loop While (i < NBgraph + 1)
Sheets("Graphiques").ChartObjects("Graphique " & i).Activate
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSheets("Graphiques").ChartObjects("Graphique " & i).Activate
Sheets("Graphiques").ChartObjects(i).Activate
ActiveChart.SeriesCollection(3).Values = "=TAB!R" & j & "C3:R" & j + 11 & "C3"
If ANNEE = True Then Sheets("Graphiques").Range("ANGRAPH") = Sheets("TAB").Range("ANNEEDEP") I = 1 j = 2 Do Sheets("Graphiques").ChartObjects(I).Activate ActiveChart.SeriesCollection(1).Values = "=TAB!R" & j & "C7:R" & j + 11 & "C7" ActiveChart.SeriesCollection(1).Name = "=TAB!R1C7" ActiveChart.SeriesCollection(2).Values = "=TAB!R" & j & "C5:R" & j + 11 & "C5" ActiveChart.SeriesCollection(2).Name = "=TAB!R1C5" ActiveChart.SeriesCollection(3).Values = "=TAB!R" & j & "C3:R" & j + 11 & "C3" ActiveChart.SeriesCollection(3).Name = "=TAB!R1C3" ActiveChart.SeriesCollection(3).ApplyDataLabels AutoText:=True, ShowValue:=False ActiveChart.SeriesCollection(3).Points(mois).ApplyDataLabels AutoText:=True, ShowValue:=True With ActiveChart.SeriesCollection(3).DataLabels.Border .Weight = 1 .LineStyle = -4105 End With ActiveChart.SeriesCollection(3).DataLabels.Shadow = True ActiveChart.SeriesCollection(3).DataLabels.Interior.ColorIndex = -4105 With ActiveChart.SeriesCollection(3).DataLabels.Font .Name = "Arial" .FontStyle = "Gras italique" .Size = 10 .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic .Background = xlAutomatic End With I = I + 1 j = j Loop While (I < NBgraph + 1) Else Sheets("Graphiques").Range("ANGRAPH") = Sheets("TAB").Range("ANNEEDEP") - 1 I = 1 j = 2 Do Sheets("Graphiques").ChartObject(I).Activate ActiveChart.SeriesCollection(1).Values = "=TAB!R" & j & "C9:R" & j + 11 & "C9" ActiveChart.SeriesCollection(1).Name = "=TAB!R1C9" ActiveChart.SeriesCollection(2).Values = "=TAB!R" & j & "C7:R" & j + 11 & "C7" ActiveChart.SeriesCollection(2).Name = "=TAB!R1C7" ActiveChart.SeriesCollection(3).Values = "=TAB!R" & j & "C5:R" & j + 11 & "C5" ActiveChart.SeriesCollection(3).Name = "=TAB!R1C5" ActiveChart.SeriesCollection(3).ApplyDataLabels AutoText:=True, ShowValue:=False ActiveChart.SeriesCollection(3).Points(12).ApplyDataLabels AutoText:=True, ShowValue:=True With ActiveChart.SeriesCollection(3).DataLabels.Border .Weight = 1 .LineStyle = -4105 End With ActiveChart.SeriesCollection(3).DataLabels.Shadow = True ActiveChart.SeriesCollection(3).DataLabels.Interior.ColorIndex = -4105 With ActiveChart.SeriesCollection(3).DataLabels.Font .Name = "Arial" .FontStyle = "Gras italique" .Size = 10 .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic .Background = xlAutomatic End With I = I + 1 j = j + 12 Loop While (I < NBgraph + 1) End If Application.ScreenUpdating = True Sheets("Graphiques").Range("ANGRAPH").Select End Sub
ActiveChart.SeriesCollection(3).Values = "=TAB!R" & j & "C3:R" & j + 11 & "C3"
ActiveChart.SeriesCollection(3).Points(12).ApplyDataLabels AutoText:=True, ShowValue:=True
ActiveChart.SeriesCollection(3).Points(12).ApplyDataLabels AutoText:=True, ShowValue:=True
ActiveChart.SeriesCollection(3).Points(12).ApplyDataLabels ShowValue:=True
ActiveChart.SeriesCollection(3).Points(12).ApplyDataLabels AutoText:=True