Axis.ScaleType Property (Excel)
Returns or sets the value axis scale type. Read/write XlScaleType.
Syntax
expression .ScaleType
expression A variable that represents an Axis object.
Remarks
XlScaleType can be one of these XlScaleType constants. |
xlScaleLinear |
xlScaleLogarithmic |
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