Partager via


Axis Members (PowerPoint)

Represents a single axis in a chart.

Methods

Name

Description

Delete

Deletes the object.

Select

Selects the object.

Properties

Name

Description

Application

When used without an object qualifier, returns an Application object that represents the Microsoft PowerPoint application. When used with an object qualifier, returns an Application object that represents the creator of the specified object (you can use this property with an Automation object to return the application of that object). Read-only.

AxisBetweenCategories

True if the value axis crosses the category axis between categories. Read/write Boolean.

AxisGroup

Returns the type of axis group. Read-only XlAxisGroup.

AxisTitle

Returns the title of the specified axis. Read-only AxisTitle.

BaseUnit

Returns or sets the base unit for the specified category axis. Read/write XlTimeUnit.

BaseUnitIsAuto

True if Microsoft Word chooses appropriate base units for the specified category axis. The default is True. Read/write Boolean.

Border

True if the font is formatted as superscript. The default is False. Read/write Variant.

CategoryNames

Returns or sets all the category names as a text array for the specified axis. Read/write Variant.

CategoryType

Returns or sets the category axis type. Read/write XlCategoryType.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

Crosses

Returns or sets the point on the specified axis where the other axis crosses. Read/write Long.

CrossesAt

Returns or sets the point on the value axis where the category axis crosses it. Applies only to the value axis. Read/write Double.

DisplayUnit

Returns or sets the unit label for the value axis. Read/write XlDisplayUnit, xlCustom, or xlNone.

DisplayUnitCustom

If the value of the DisplayUnit property is xlCustom, returns or sets the value of the displayed units. Read/write Double.

DisplayUnitLabel

Returns the DisplayUnitLabel object for the specified axis. Returns null if the HasDisplayUnitLabel property is set to False. Read-only.

Format

Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.

HasDisplayUnitLabel

True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis. The default is True. Read/write Boolean.

HasMajorGridlines

True if the axis has major gridlines. Read/write Boolean.

HasMinorGridlines

True if the axis has minor gridlines. Read/write Boolean.

HasTitle

True if the axis or chart has a visible title. Read/write Boolean.

Height

Returns the height, in points, of the object. Read-only Double.

Left

Returns the distance, in points, from the left edge of the object to the left edge of the chart area. Read-only Double.

LogBase

Returns or sets the base of the logarithm when you are using log scales. Read/write Double.

MajorGridlines

Returns the major gridlines for the specified axis. Read-only Gridlines.

MajorTickMark

Returns or sets the type of major tick mark for the specified axis. Read/write XlTickMark.

MajorUnit

Returns or sets the major units for the value axis. Read/write Double.

MajorUnitIsAuto

True if Microsoft Word calculates the major units for the value axis. Read/write Boolean.

MajorUnitScale

Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit.

MaximumScale

Returns or sets the maximum value on the value axis. Read/write Double.

MaximumScaleIsAuto

True if Microsoft Word calculates the maximum value for the value axis. Read/write Boolean.

MinimumScale

Returns or sets the minimum value on the value axis. Read/write Double.

MinimumScaleIsAuto

True if Microsoft Word calculates the minimum value for the value axis. Read/write Boolean.

MinorGridlines

Returns the minor gridlines for the specified axis. Read-only Gridlines.

MinorTickMark

Returns or sets the type of minor tick mark for the specified axis. Read/write XlTickMark.

MinorUnit

Returns or sets the minor units on the value axis. Read/write Double.

MinorUnitIsAuto

True if Microsoft Word calculates minor units for the value axis. Read/write Boolean.

MinorUnitScale

Returns or sets the minor unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit.

Parent

Returns the parent for the specified object. Read-only Object.

ReversePlotOrder

True if Microsoft Word plots data points from last to first. Read/write Boolean.

ScaleType

Returns or sets the value axis scale type. Read/write XlScaleType.

TickLabelPosition

Describes the position of tick-mark labels on the specified axis. Read/write XlTickLabelPosition.

TickLabels

Returns the tick-mark labels for the specified axis. Read-only TickLabels.

TickLabelSpacing

Returns or sets the number of categories or series between tick-mark labels. Read/write Long.

TickLabelSpacingIsAuto

Returns or sets a value that indicates whether the tick label spacing is automatic. Read/write Boolean.

TickMarkSpacing

Returns or sets the number of categories or series between tick marks. Read/write Long.

Top

Returns the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart). Read-only Double.

Type

Returns the axis type. Read-only XlAxisType.

Width

Returns the width, in points, of the object. Read-only Double.