April 2006
Beginner
1114 pages
98h 16m
English
axis.AxisTitle
Returns the AxistTitle object for the axis. Check the HasTitle property before using this object, and use the AxisTitle Caption property to change the title as shown by the following code:
Sub ChangeAxisTitle( )
Dim chrt As Chart, ax As Axis
Set chrt = ActiveSheet
Set ax = chrt.Axes(xlCategory, xlPrimary)
If ax.HasTitle Then _
ax.AxisTitle.Caption = "New Caption"
End SubRead now
Unlock full access