|
本帖最后由 kris1977 于 2019-6-25 17:51 编辑
我用以下代码在散点图中新建一个数据系列,同时想设置点的颜色,但没有任何变化。请大家帮我改改看!!!
- ActiveChart.SeriesCollection.NewSeries
- ActiveChart.FullSeriesCollection(1).Name = p_nam
- ActiveChart.FullSeriesCollection(1).XValues = "=" & sh1_nam & "!$S$2:$S$10000"
- ActiveChart.FullSeriesCollection(1).Values = "=" & sh1_nam & "!$T$2:$T$10000"
- ActiveChart.FullSeriesCollection(1).Select
- With Selection
- .MarkerStyle = 5
- .MarkerSize = 4
- End With
- With Selection.Format.Line
- .ForeColor.RGB = RGB(191, 191, 191)
- End With
复制代码
|
|