XlSparklineAxisScaling Enum

Lists values used to specify how to calculate the minimum and maximum values for the vertical axis of a sparkline group.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum XlSparklineAxisScaling

VB.NET

Public Enum XlSparklineAxisScaling

Members

Name	Description
Individual	Specifies that the minimum or maximum value for the sparkline vertical axis should be automatically set to the lowest or highest value calculated individually for each sparkline in the group.
Custom	Specifies that the minimum or maximum value for the sparkline vertical axis should be set to the custom value defined by the XlSparklineGroup.ManualMin or XlSparklineGroup.ManualMax property, respectively.
Group	Specifies that the minimum or maximum value for the sparkline vertical axis should be calculated automatically and shared across all the sparklines in the group.

Related API Members

The following properties accept/return XlSparklineAxisScaling values:

• XlSparklineGroup.MaxScaling
• XlSparklineGroup.MinScaling

Remarks

The values listed by this enumeration are used to set the XlSparklineGroup.MinScaling and XlSparklineGroup.MaxScaling properties.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlSparklineAxisScaling enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/SparklineActions.cs#L266

// Set the custom minimum value for the vertical axis.
group.MinScaling = XlSparklineAxisScaling.Custom;
group.ManualMin = 1000.0;

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/SparklineActions.vb#L228

' Set the custom minimum value for the vertical axis.
group.MinScaling = XlSparklineAxisScaling.Custom
group.ManualMin = 1000.0