ShowLabels Property

ShowLabels returns or sets the show labels state for an axis. It has a Boolean value. When it is set to 'True', all major ticks on the selected axis are displayed with a label. If it is set to 'False', the labels are not displayed.

Syntax

object.ShowLabels

object.ShowLabels = Show

Parameter	Type	Description
Show	Boolean	required

Example 1

This example demonstrates how to return whether or not the labels of an axis are displayed.

Debug.Print Axis.ShowLabels

Example 2

This example demonstrates how to display the labels of an axis.

Axis.ShowLabels = True

Used by: Axis object