Share via

Scalings Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

Returns a ChScaling object for the specified chart or series.

expression.Scalings(Dimension)

expression   Required. An expression that returns one of the objects in the Applies To list.

ChartDimensionsEnum

ChartDimensionsEnum can be one of these ChartDimensionsEnum constants.
chDimBubbleValues
chDimCategories
chDimCharts
chDimCloseValues
chDimFilter
chDimFormatValues
chDimHighValues
chDimLowValues
chDimOpenValues
chDimRValues
chDimSeriesNames
chDimThetaValues
chDimValues
chDimXValues
chDimYValues

Example

This example sets the minimum value for the specified ChScaling object.

  Sub SetScaling()

   Dim chConstants

   Set chConstants = ChartSpace1.Constants

   ChartSpace1.Charts(0).SeriesCollection(0).Scalings _
                 (chConstants.chDimCategories).Minimum = -10
End Sub