ScaleType Property

Microsoft Excel Visual Basic

XlScaleType can be one of these XlScaleType constants.
xlScaleLinear
xlScaleLogarithmic

expression.ScaleType

expression    Required. An expression that returns one of the objects in the Applies To list.

Remarks

A logarithmic scale uses base 10 logarithms.

Example

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

Charts("Chart1").Axes(xlValue).ScaleType = xlScaleLogarithmic