XlSparkScale Enumeration
Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
Version Information
Version Added: Excel 2010
Name |
Value |
Description |
|---|---|---|
xlSparkScaleCustom |
3 |
The minimum or maximum value for the vertical axis of the sparkline has a user-defined value. |
xlSparkScaleGroup |
1 |
The minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value. |
xlSparkScaleSingle |
2 |
The minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value. |
Remarks
The constants of the XlSparkScale enumeration correspond to the settings of the Vertical Axis Minimum Value Options and the Vertical Axis Maximum Value Options on the Axis drop-down list on the Sparkline Tools Design tab of the ribbon.