ScaleType Property

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

XlScaleType can be one of these XlScaleType constants.
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 to use a logarithmic scale.

myChart.Axes(xlValue).ScaleType = xlScaleLogarithmic