需要更改表名的,如果不改的话,这样 选中图表之后,执行代码.图表不在选中状态执行出错. Sub chart() With ActiveChart.Axes(xlValue) .MinimumScale = Range("a2") .MaximumScale = Range("a1") .MajorUnit = Range("a3") .CrossesAt = Range("a4") End With End Sub
sub chart() ChartObjects("图表名").Activate With ActiveChart.Axes(xlValue) .MinimumScale = range("a2") .MaximumScale = range("a1") .MajorUnit = range("a3") .CrossesAt = range("a4") End With end sub