Skip to main content

XlSparklineGroup.MinScaling Property

Specifies how the vertical axis minimums for the sparklines in the sparkline group are calculated.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

public XlSparklineAxisScaling MinScaling { get; set; }

Property Value

Type Description
XlSparklineAxisScaling

A XlSparklineAxisScaling enumeration member that determines how to calculate vertical axis minimums.

Available values:

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.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

// Create a sparkline group.
XlSparklineGroup group = new XlSparklineGroup(XlCellRange.FromLTRB(1, 1, 4, 6), XlCellRange.FromLTRB(5, 1, 5, 6));
// Set the sparkline color.
group.ColorSeries = XlColor.FromTheme(XlThemeColor.Accent1, 0.0);
// Change the sparkline group type to "Column".
group.SparklineType = XlSparklineType.Column;
// Set the custom minimum value for the vertical axis.
group.MinScaling = XlSparklineAxisScaling.Custom;
group.ManualMin = 1000.0;
// Set the automatic maximum value for all sparklines in the group. 
group.MaxScaling = XlSparklineAxisScaling.Group;
sheet.SparklineGroups.Add(group);
See Also