CaptionHAlignment Property

See Also         Example         Applies To

Returns or sets the horizontal alignment for the detail footer label in the specified PivotTable list. Read/write PivotHAlignmentEnum.

Remarks

Captions can be displayed only to the left of aggregates in the detail footer. Use the CaptionHAlignment property to align the caption close to the aggregate (plHAlignRight) or to align the caption close to the left edge of the footer (plHAlignLeft). If there is another aggregate displayed to the left, the caption is displayed to the right of the other aggregate. If there is not enough room to display the caption, it is not visible.