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