VBA chart 語法

vba

kisara 2023-10-19 16:33:07 ‧ 510 瀏覽

分享至

各位高手請教, 有幾個語法不會寫
' 巨集1 巨集
'

'
ActiveSheet.ChartObjects("圖表 5").Activate
ActiveChart.Axes(xlCategory).Select
Selection.MajorTickMark = xlNone
ActiveChart.Axes(xlValue).Select
Selection.MajorTickMark = xlNone
ActiveChart.Axes(xlValue).MajorGridlines.Select
With Selection.Format.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorBackground1
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.150000006
.Transparency = 0
End With
End Sub
1.Y軸刻度主要類型外側改無
2.X軸刻度次要類形外側改無
3.X方向背景橫線黑色改灰色