Display UnitLabel Properties

Name

Returns

Description

AutoScaleFont

Variant

Set/Get whether the font size will change automatically if the parent chart changes sizes

Caption

String

Set/Get the unit label's text

Characters

Characters

Read-only. Parameters: [Start], [Length]. Returns an object containing all the characters in the unit label. Allows manipulation on a character-by-character basis

Format

ChartFormat

Read-only. Returns the ChartFormat object, which controls the line, fill, and effect formatting for the chart area

HorizontalAlignment

xlAlign

Set/Get how you want the unit label to be horizontally aligned. Use the xlAlign constants

Name

Returns

Description

Left

Double

Set/Get the distance from the left edge of the unit label text area to the chart's left edge

Name

String

Read-only. Returns the name of the Display-UnitLabel object

Orientation

XlOrientation

Set/Get the angle of the text for the unit label. The value can be in degrees (from -90 to 90) or one of the XlOrientation constants

Position

XlChartElement Position

Set/Get where the unit label is going to be located in relation to points or trendlines

Reading Order

Long

Set/Get how the text is read (from left to right or right to left). Only applicable in appropriate languages

Shadow

Boolean

Set/Get whether the unit label has a shadow effect

Text

String

Set/Get the unit label's text

Top

Double

Set/Get the distance from the top edge of the unit label text area to the chart's top edge

Vertical Alignment

xlVAlign

Set/Get how you want the unit label to be horizontally aligned. Use the xlVAlign constants

Was this article helpful?

0 0

Post a comment