本来想在VC中将点线图(xlLineMarkers)的线不显示,只显示点(类似于散点图),但发现VC中对于Series类并有设置线条属性的函数,因此在Excel中录制了如下一段操作的宏,尝试找到突破口:
Sub Macro9()
'
' Macro9 Macro
'
'
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("Data!$A:$A,Data!$K:$K")
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.ColorIndex = 6
.Weight = xlThick
.LineStyle = xlNone
End With
End Sub以上宏在Excel中运行后能达到我的目的,但我不知道怎么把这段宏在VC中用代码来实现,疑问点是Selection.Border这个怎么在VC中表示?baidu,google了一圈找不到答案,麻烦高手帮忙,多谢多谢~~~~ExcelVC宏
Sub Macro9()
'
' Macro9 Macro
'
'
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("Data!$A:$A,Data!$K:$K")
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.ColorIndex = 6
.Weight = xlThick
.LineStyle = xlNone
End With
End Sub以上宏在Excel中运行后能达到我的目的,但我不知道怎么把这段宏在VC中用代码来实现,疑问点是Selection.Border这个怎么在VC中表示?baidu,google了一圈找不到答案,麻烦高手帮忙,多谢多谢~~~~ExcelVC宏
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货