.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

SparklineVerticalAxis Interface

Contains scaling options for the vertical axis of a sparkline group.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.1.Core.dll


public interface SparklineVerticalAxis


An object exposing the SparklineVerticalAxis interface can be accessed from the SparklineGroup.VerticalAxis property. Use the object’s properties to specify how to calculate the minimum and maximum values for the vertical axis of a sparkline group.

The example below demonstrates how to specify custom scaling values for the vertical axis.

Worksheet worksheet = workbook.Worksheets["SparklineExamples"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Create a group of column sparklines.
SparklineGroup columnGroup = worksheet.SparklineGroups.Add(worksheet["G4:G7"], worksheet["C4:F4,C5:F5,C6:F6, C7:F7"], SparklineGroupType.Column);

// Specify the vertical axis options.
SparklineVerticalAxis verticalAxis = columnGroup.VerticalAxis;
// Set the custom minimum value for the vertical axis.
verticalAxis.MinScaleType = SparklineAxisScaling.Custom;
verticalAxis.MinCustomValue = 0;
// Set the custom maximum value for the vertical axis.
verticalAxis.MaxScaleType = SparklineAxisScaling.Custom;
verticalAxis.MaxCustomValue = 12000;
See Also