TickLabels.Offset Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns or sets a Long value that represents the distance between the levels of labels, and the distance between the first level and the axis line.
public:
property int Offset { int get(); void set(int value); };
public int Offset { get; set; }
member this.Offset : int with get, set
Public Property Offset As Integer
Property Value
Examples
This example sets the label spacing of the category axis for the first chart in the active document to twice the current setting, if the offset is less than 500.
<span class="label">With ActiveDocument.InlineShapes(1)
If .HasChart Then
With .Chart.Axes(xlCategory).TickLabels
If .</span>
<i>Offset</i>
<span class="label">< 500 then .</span>
<i>Offset</i>
<span class="label">= .</span>
<i>Offset</i>
<span class="label">* 2 End If End With End IfEnd With</span>
Remarks
The default distance is 100 percent, which represents the default spacing between the axis labels and the axis line. The value can be an integer percentage from 0 through 1000, relative to the axis label’s font size.