Scalings Property

  • Article

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

Applies to | ChChart Object | ChSeries Object

See Also | Scaling Property