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