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 the XlScaleType constants.
A logarithmic scale uses base 10 logarithms.
Example
This example sets the value axis on Chart1 to use a logarithmic scale.
Charts("Chart1").Axes(xlValue).ScaleType = xlScaleLogarithmic
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.