Axis.ScaleType procedure builder

Axis.ScaleType (Excel)

Returns or sets the value axis scale type.

xlScaleLinear - Linear, xlScaleLogarithmic - Logarithmic.

XlScaleType can be one of the XlScaleType constants. A logarithmic scale uses base 10 logarithms.

ActiveChart.Axes(1).ScaleType = xlScaleLinear