Attribute VB_Name = "testchart1" Sub ƒeƒXƒg() Dim chart1 As Chart Set chart1 = Charts.Add(Before:=ActiveSheet) chart1.SetSourceData Worksheets("Sheet1").Range("B2:E6") End Sub