XlSparkScale Enum

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public enum class XlSparkScale

public enum XlSparkScale

Public Enum XlSparkScale

Inheritance: Enum
XlSparkScale

Fields

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.

Applies to