Share via

DetailLeftOffset Property

  • Article

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

Applies to | PivotColumnMember Object

See Also | DetailTopOffset Property | TopOffset Property