Share via

Axis.ScaleType Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Charts("Chart1").Axes(xlValue).ScaleType = xlScaleLogarithmic

See Also