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. |
| xlScaleLinear |
| 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