实时错误424 要求对象_VBA: 运行时错误‘424：要求对象（设置坐标轴标题时）

    文章背景：有一组x-y的数据，想通过录制宏的方式，实现画图的自动化。本文以散点图为例，需要在图中添加坐标轴的标题。录制好宏后，运行代码时，报错如下：

通过查阅相关资料，发现程序报错的可能原因如下：

Although you have recorded using a macro and it should automatically play back, it doesn't seem to in the case of label text. You first have to create the AxisTitle object - an axis doesn't automatically have one.

解决方法：

(1)删去宏内有关Axes的相关代码，

   ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "y"   Selection.Format.TextFrame2.TextRange.Characters.Text = "y"   ActiveChart.Axes(xlCategory).AxisTitle.Select   Ac