vba 设置坐标轴

1.辅助线虚线

("图表1").Activate

(xlValue).Select

(xlValue).

With

.Visible = msoTrue

.DashStyle = msoLineDash

End With

 

轴坐标向右

(xlCategory).Select

= xlInside

 

轴坐标向上

= xlInside