Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Referencing Charts and Chart Objects in VBA Code
Sub SpecifyLocation()
    Dim WS As Worksheet
    Set WS = Worksheets("Sheet1")
    WS.Shapes.AddChart(xlColumnClustered, Left:=100, Top:=150, Width:=400, Height:=300).Select
    ActiveChart.SetSourceData Source:=WS.range("A1:E4")
End Sub