AXES

Macro Sheets Only

Equivalent to choosing the Axes command from the Insert menu available when a chart is displayed in the active window. Controls whether the axes on a chart are visible. There are two syntax forms of this function. Syntax 1 is for 2-D charts; syntax 2 is for 3-D charts.

Syntax 1

For 2-D charts

AXES(x_primary, y_primary, x_secondary, y_secondary)
AXES?(x_primary, y_primary, x_secondary, y_secondary)

Syntax 2

For 3-D charts

AXES(x_primary, y_primary, z_primary)
AXES?(x_primary, y_primary, z_primary)

Arguments are logical values corresponding to the check boxes in the Axes dialog box.

• If an argument is TRUE, Microsoft Excel selects the check box and displays the corresponding axis.
• If an argument is FALSE, Microsoft Excel clears the check box and hides the corresponding axis.
• If an argument is omitted, the display of that axis is unchanged.

X_primary corresponds to the primary category (x) axis.

Y_primary corresponds to the primary value (y) axis.

Z_primary corresponds to the value (z) axis on the primary 3-D chart.

X_secondary corresponds to the secondary category (x) axis on a 2-D chart only.

Y_secondary corresponds to the secondary value (y) axis on a 2-D chart only.

If a 2-D chart has no secondary axis, only the first two arguments are used.

Related Function

GRIDLINES Controls whether chart gridlines are visible

List of Command-Equivalent Functions