ScaleType Property
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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.

A logarithmic scale uses base 10 logarithms.

This example sets the value axis to use a logarithmic scale.

myChart.Axes(xlValue).ScaleType = xlScaleLogarithmic
Show:
© 2016 Microsoft