怪不得我执行出错呢。 这样改了下,也行。 Range("A1:B8").Select Charts.Add ActiveChart.ChartType = xlColumnClustered ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:B8"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1" ActiveSheet.ChartObjects.Select '不用具体名称就可以了[em05] ActiveChart.SeriesCollection(1).Select ActiveChart.ChartGroups(1).VaryByCategories = True |