Format related procedures in class Axis (PowerPoint VBA)

This page presents procedures from class Axis related to the theme Format: Format, Height, TickLabelSpacing, TickLabelSpacingIsAuto, TickMarkSpacing and Width

Format

Returns the line, fill, and effect formatting for the object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveWindow.RangeFromPoint.Chart.Axes(1).Format

Height

Returns the height, in points, of the object.

Dim dblHeight As Double
dblHeight = ActiveWindow.RangeFromPoint.Chart.Axes(1).Height

TickLabelSpacing

Returns or sets the number of categories or series between tick-mark labels.

This property applies only to category and series axes. It can be a value from 1 through 31999. Tick-mark label spacing on the value axis is always calculated by Microsoft Word.

ActivePresentation.Slides(1).Shapes(1).Chart.Axes(1).TickLabelSpacing = 10

TickLabelSpacingIsAuto

Returns or sets a value that indicates whether the tick label spacing is automatic.

The TickLabelSpacing property returns the current tick label spacing, whether or not the setting is automatic.

ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabelSpacingIsAuto = True

TickMarkSpacing

Returns or sets the number of categories or series between tick marks.

This property applies only to category and series axes. It can be a value from 1 through 31999. Use the MajorUnit and MinorUnit properties to set tick-mark spacing on the value axis.

ActivePresentation.Slides(1).Shapes(1).Chart.Axes(1).TickMarkSpacing = 5

Width

Returns the width, in points, of the object.

Dim dblWidth As Double
dblWidth = ActiveWindow.RangeFromPoint.Chart.Axes(1).Width