Class DisplayUnitLabel (PowerPoint VBA)

The class DisplayUnitLabel represents a unit label on an axis in the specified chart.

Class Axis gives access to class DisplayUnitLabel.

To use a DisplayUnitLabel class variable it first needs to be instantiated, for example

Dim dul as DisplayUnitLabel
Set dul = ActiveWindow.RangeFromPoint.Chart.Axes(1).DisplayUnitLabel

DisplayUnitLabel class variables can be set using the Axis.DisplayUnitLabel procedure.

Methods

Delete - Deletes the object.

Select - Selects the object.

Properties

Caption returns or sets the display unit label text.

Characters returns a ChartCharacters object that represents a range of characters within the object text. You can use the ChartCharacters object to format characters within a text string.

Format returns the line, fill, and effect formatting for the object.

Formula returns or sets the object's formula in A1-style notation.

FormulaLocal returns or sets the formula for the object, using A1-style references in the language of the user.

FormulaR1C1 returns or sets the formula for the object, using R1C1-style notation in the language of the macro.

FormulaR1C1Local returns or sets the formula for the object, using R1C1-style notation in the language of the user.

Height returns the height, in points, of the object.

HorizontalAlignment returns or sets the horizontal alignment for the specified object.

Left returns or sets the distance, in points, from the left edge of the object to the left edge of the chart area.

Name returns the name of the object.

Orientation returns or sets the text orientation. Read/write Long.

Position returns or sets the position of the unit label on an axis in the chart.

ReadingOrder returns or sets an XlReadingOrder constant that represents the reading order for the specified object.

Shadow returns or sets a value that indicates whether the object has a shadow.

Text returns or sets the text for the specified object.

Top returns or sets the distance, in points, from the top edge of the object to the top of the first row (on a worksheet) or the top of the chart area (on a chart).

VerticalAlignment returns or sets the vertical alignment of the specified object.

Width returns the width, in points, of the object.

ChartCharacters - Represents characters in an object that contains text.

ChartFormat - Provides access to the OfficeArt formatting for chart elements.