ScaleType Property

Applies To

Axis object.

Description

Returns or sets the value axis scale type. Can be one of the following XlScaleType constants: xlScaleLinear or xlScaleLogarithmic. Applies only to the value axis. Read/write Long.

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