Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Specifying the Source Data for the Chart by using the SetSourceData method of the Chart object

Sub width()     Dim myChartObject As ChartObject     Set myChartObject = ActiveSheet.ChartObjects.Add(Left:=200, Top:=200, _         Width:=400, Height:=300)          myChartObject.Chart.SetSourceData Source:= _         ActiveWorkbook.Sheets("Chart Data").Range("A1:E5") End Sub