Axis Title Properties

Name

Returns

Description

AutoScaleFont

Variant

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

Border

Border

Read-only. Returns the border's properties around the selected axis title

Caption

String

Set/Get the axis title's text

Characters

Characters

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

Fill Format

ChartFill

Read-only. Returns an object containing fill formatting options for the chart axis title

Font

Font

Read-only. Returns an object containing Font options for the chart axis title

Format

ChartFormat

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

Horizontal Alignment

xlAlign

Set/Get how you want the axis title to be horizontally aligned. Use the xlAlign constants

IncludeLayout

Boolean

Set/Get whether the axis title will occupy the chart layout space when a chart layout is being determined

Interior

Interior

Read-only. Returns an object containing options to format the area in the chart title text area (for example, interior color)

Name

Returns

Description

Left

Double

Set/Get the distance from the left edge of the axis title text area to the chart's left edge

Name

String

Read-only. Returns the name of the axis title object

Position

xlChart Element Position

Set/Get the position of the axis title on the chart

Orientation

XlOrientation

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

ReadingOrder

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 axis title has a shadow effect

Text

String

Set/Get the axis title's text

Top

Double

Set/Get the distance from the top edge of the axis title text area to the chart's top edge

Vertical Alignment

xlVAlign

Set/Get how you want the axis title to be horizontally aligned. Use the xlVAlign constants

isTitle Methods

Name

Returns

Parameters Description

Delete

Variant

Deletes the axis title from the axis

Select

Variant

Selects the axis title on the chart

0 0

Post a comment