Scalings Property
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.
Dimension Required ChartDimensionsEnum. Specifies the dimension to be returned.
| 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