请教: wps vba 如何设置图表折线的粗细

2020-10-29 10:24:26 390 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

如何使用xlwings库设置图表内折线的线型、颜色、数值点大小、数值点形状、数值点颜色等----关于Python里xlwings库对Excel表格的操作（三十七）如何使用xlwings库设置图表内折线的线型、颜色、数值点大小、数值点形状、数值点颜色等----关于Python里xlwings库对Excel表格的操作（三十七）阅读详情

多次尝试都失败了，请各位大侠出手，谢谢了！

'wps 表格版本9.1.0.4940

Dim oSeries As Series
With ActiveChart
Set oSeries = .SeriesCollection.NewSeries
oSeries.Name = "sbp"
oSeries.ChartType = xlLine
oSeries.Format.Line.ForeColor.ObjectThemeColor = vbRed
oSeries.Format.Line.Weight = xlThick'不起作用

.SeriesCollection(1).Name = "sbp"
.SeriesCollection(1).Smooth = cbSmooth.Value
.SeriesCollection(1).Format.Line.Visible = True
.SeriesCollection(1).Format.Line.Weight = xlThick'不起作用
.SeriesCollection(1).Format.Line.ForeColor.ObjectThemeColor = 255

.SeriesCollection(1).Border.Color = vbRed
.SeriesCollection(1).Border.Weight = xlThick'不起作用
.SeriesCollection(1).Border.LineStyle = xlContinuous

End With

...全文