Axis.ScaleType (Excel)

Returns or sets the value axis scale type. Possible return values are xlScaleLinear - Linear, xlScaleLogarithmic - Logarithmic.

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

ActiveChart.Axes(1).ScaleType = xlScaleLinear