xlSparkScale

Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.

xlSparkScaleCustomThe minimum or maximum value for the vertical axis of the sparkline has a user-defined value (3)
xlSparkScaleGroupThe minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value (1)
xlSparkScaleSingleThe minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value (2)

xlSparkScaleCustom
The minimum or maximum value for the vertical axis of the sparkline has a user-defined value (3)
xlSparkScaleGroup
The minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value (1)
xlSparkScaleSingle
The minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value (2)

REMARKS
* Added in 2010.
* 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.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top