XlSparklineGroup.ManualMax Property

Gets or sets the maximum for the vertical axis that is the same for all sparklines in the sparkline group.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public double ManualMax { get; set; }

VB.NET

Public Property ManualMax As Double

Property Value

Type	Description
Double	A Double value that specifies the maximum value for the vertical axis.

Remarks

The ManualMax property is in effect if the XlSparklineGroup.MaxScaling property is set to the XlSparklineAxisScaling.Custom value.

Example

Note

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

SparklineActions.cs

// 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);

SparklineActions.vb

' Create a sparkline group.
Dim group As 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)