全部选中---选择边框---线性(小三角)---根据自己的需求选择不同类型的线,和不容粗细的线
几千条,用宏:
Sub test()
For Each ichart In ActiveSheet.ChartObjects
ichart.Activate
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.Weight = xlThick '变为粗线
.LineStyle = xlContinuous
End With
Next
End Sub
Sub x()
For i = 1 To 121
ActiveChart.SeriesCollection(i).Select
Selection.MarkerSize = 4
Selection.Format.Line.Weight = 0.25
Next
End Sub