Offset property (Excel Graph)
Returns or sets the distance between each of the levels of labels, and the distance between the first level and the axis line. The default is 100, which represents the spacing between the axis labels and axis line. The value can be an integer from 0 to 1000, relative to the size of the font of the axis label. Read/write Long.
expression.Offset
expression Required. An expression that returns one of the objects in the Applies To list.
This example doubles the existing tick-mark spacing on the value axis in myChart if the offset is less than 500.
With myChart.Axes(xlCategory).TickLabels
If .Offset < 500 then
.Offset = .Offset * 2
End If
End With
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.