Axis.ScaleType Property (Excel)

Returns or sets the value axis scale type. Read/write XlScaleType .

Syntax

expression. ScaleType

expression A variable that represents an [Axis](./Excel.Axis(Graph object).md) object.

Remarks

XlScaleType can be one of these XlScaleType constants.
xlScaleLogarithmic

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

See also

Axis Object