The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

SparklinePoints Interface

Contains marker options for data points on the sparklines in a sparkline group.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

public interface SparklinePoints
Public Interface SparklinePoints
public interface SparklinePoints
Public Interface SparklinePoints
public interface SparklinePoints
Public Interface SparklinePoints

Remarks

Use the SparklineGroup.Points property to access an object exposing the SparklinePoints interface. Use the object's properties to display important data points on a sparkline. For example, you can highlight markers for the first and last data points (SparklinePoints.First and SparklinePoints.Last), highest and lowest values (SparklinePoints.Highest and SparklinePoints.Lowest), or all values that are less than zero (SparklinePoints.Negative).

The example below demonstrates how to use the SparklinePoints.Markers property to show data markers on the line sparklines, and set specific colors for the highest and lowest data points on each sparkline in the group.

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

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

// Customize the group appearance.
// Set the sparkline color.
lineGroup.SeriesColor = Color.FromArgb(0x1F, 0x49, 0x7D);

// Set the sparkline weight.
lineGroup.LineWeight = 1.5;

// Display data markers on the sparklines and specify their color.
SparklinePoints points = lineGroup.Points;
points.Markers.IsVisible = true;
points.Markers.Color = Color.FromArgb(0x4B, 0xAC, 0xC6);

// Highlight the highest and lowest points on each sparkline in the group.
points.Highest.Color = Color.FromArgb(0xA9, 0xD6, 0x4F);
points.Lowest.Color = Color.FromArgb(0x80, 0x64, 0xA2);
See Also