April 2006
Beginner
1114 pages
98h 16m
English
axis.CrossesAt [= setting]
For 2-D charts with Crosses set to xlAxisCrossesCustom, sets or returns the point on the axis where the other axis starts. For example, the following code moves the category axis up to 100,000 on the value axis:
Sub MoveCategoryAxisUp( )
Dim chrt As Chart, ax As Axis
Set chrt = ActiveSheet
Set ax = chrt.Axes(xlValue, xlPrimary)
ax.Crosses = xlAxisCrossesCustom
ax.CrossesAt = 100000
End SubRead now
Unlock full access