Sub CreatGraph(j As Integer)
Charts.Add
With ActiveChart
.ChartType = xlColumnStacked
.SetSourceData source:=Worksheets(FeuilName).Range("A300:D303"), PlotBy:=xlRows
.SetElement (msoElementDataLabelCenter)
.Legend.Delete
.location Where:=xlLocationAsObject, Name:=TestName
End With
NbGraph = Worksheets(AbstractName).ChartObjects.Count
With Worksheets(TestName).ChartObjects(NbGraph)
.Left = Cells(j, Columna).Left
.Top = Cells(j, Columna).Top
.Height = Cells(j, Columna).Height
.Width = Cells(j, Columna).Width
End With
End Sub