April 2006
Beginner
1114 pages
98h 16m
English
axis.AxisBetweenCategories [= setting]
For category axes, True moves the start point of the category axis away from the value axis so that plotted series move in from the edges of the chart. Default is False. For other axes, causes an error. To see the effect of this property, try the following code on a line chart:
Sub MoveCategoryAxis( )
Dim chrt As Chart, ax As Axis
Set chrt = ActiveSheet
Set ax = chrt.Axes(xlCategory, xlPrimary)
ax.AxisBetweenCategories = True
End SubRead now
Unlock full access