随便加点内容就可以了- Sub 宏1()
- Range("A1:C26").Select
- ActiveSheet.Shapes.AddChart.Select
- ActiveChart.ChartType = xlLine
- ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$C$26")
- ActiveChart.SeriesCollection(1).Select
- With Selection.Format.Line
- .Visible = msoTrue
- .ForeColor.RGB = RGB(0, 176, 80)
- .ForeColor.RGB = RGB(255, 0, 0)
- .Transparency = 0
- End With
- ActiveChart.SeriesCollection(2).Select
- With Selection.Format.Line
- .Visible = msoTrue
- .ForeColor.RGB = RGB(255, 0, 0)
- .ForeColor.RGB = RGB(112, 48, 160)
- .Transparency = 0
- End With
- Cells(1, 1).Select
复制代码 |