ScaleType Property [Excel 2003 VBA Language Reference]

  • Article

XlScaleType

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

Applies to | Axis Object