SCALE

Macro Sheets Only

Equivalent to choosing the Selected Axes command from the Format menu when a chart's axis is selected, and then choosing the Scale tab. There are five syntax forms of this function. Syntax 5 of SCALE applies if the selected axis is a value (z) axis on a 3-D chart. Use this syntax of SCALE to change the position, formatting, and scaling of the value axis.

Syntax 5

SCALE(min_num, max_num, major, minor, cross, logarithmic, reverse, min)
SCALE?(min_num, max_num, major, minor, cross, logarithmic, reverse, min)

The first five arguments correspond to the five range variables in the Format Axis dialog box, as shown in the following list. Each argument can be either the logical value TRUE or a number.

Min_num corresponds to the Minimum box and is the minimum value for the value axis.

Max_num corresponds to the Maximum box and is the maximum value for the value axis.

Major corresponds to the Major Unit box and is the major unit of measure.

Minor corresponds to the Minor Unit box and is the minor unit of measure.

Cross corresponds to the Floor (XY Plane) Crosses At box.

The last three arguments are logical values corresponding to check boxes in the Scale tab. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box.

Logarithmic corresponds to the Logarithmic Scale check box.

Reverse corresponds to the Values In Reverse Order check box.

Min corresponds to the Floor (XY Plane) Crosses At Minimum Value check box.

Related Functions

Syntax 1 Changes the position, formatting, and scaling of the category axis in 2-D charts

Syntax 2 Changes the position, formatting, and scaling of the value axis in 2-D charts

Syntax 3 Changes the position, formatting, and scaling of the category axis in 3-D charts

Syntax 4 Changes the position, formatting, and scaling of the series axis in 3-D charts

List of Command-Equivalent Functions