Muokkaa

Jaa


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.