DetailLeftOffset Property

Microsoft Office Web Components Visual Basic

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