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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlSparkScale
'Usage
Dim instance As XlSparkScale
public enum XlSparkScale
Members
| Member name | Description | |
|---|---|---|
| xlSparkScaleGroup | The minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value. | |
| xlSparkScaleSingle | The minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value. | |
| xlSparkScaleCustom | The minimum or maximum value for the vertical axis of the sparkline has a user-defined 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.