Syntax

expression.ScaleType

expression A variable that represents an Axis object.

Remarks

XlScaleType can be one of these XlScaleType constants.
xlScaleLinear
xlScaleLogarithmic

A logarithmic scale uses base 10 logarithms.

Example

This example sets the value axis in Chart1 to use a logarithmic scale.

Visual Basic for Applications
Charts("Chart1").Axes(xlValue).ScaleType = xlScaleLogarithmic
scale scale type scaletype scaletype property

See also: