Attribute VB_Name = "testchartedit6" Sub ƒeƒXƒg() Dim chart1 As Chart Dim legend1 As Legend Dim font1 As Font Set chart1 = Charts.Add chart1.SetSourceData Worksheets("Sheet1").Range("B2:E6") chart1.HasLegend = True Set legend1 = chart1.Legend legend1.Position = xlLegendPositionBottom Set font1 = legend1.Font font1.Size = 20 End Sub