DetailLeftOffset Property
Returns or sets a Long value that represents the number of pixels that the data in the detail area is offset to the left. Use this property to move the data in the detail area to the left. Read/write.
expression.DetailLeftOffset
expression Required. An expression that returns a PivotColumnMember object.
Remarks
Setting this property to a negative value will result in a run-time error.
Example
This example moves the data in the detail area of PivotTable1 10 pixels to the left.
PivotTable1.ActiveData.ColumnAxis.ColumnMember.DetailLeftOffset = 10