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.v20.2.Core.dll
NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core
Declaration
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-t253492
// 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);