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+
Row

Sparkline Interface

Represents a single sparkline in the sparkline group.

Namespace: DevExpress.Spreadsheet

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

Declaration

public interface Sparkline
Public Interface Sparkline
public interface Sparkline
Public Interface Sparkline

Remarks

The Sparkline object is contained within the SparklineCollection collection. The SparklineGroup.Sparklines property provides access to a collection that contains all sparklines for the specified sparkline group.

The code example below demonstrates how to use the SparklineCollection.Add method to add a new Sparkline object to the existing sparkline group.

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

// Create a group of line sparklines.
SparklineGroup quarterlyGroup = worksheet.SparklineGroups.Add(worksheet["G4:G6"], worksheet["C4:F4,C5:F5,C6:F6"], SparklineGroupType.Line);
// Add one more sparkline to the existing group.
quarterlyGroup.Sparklines.Add(6, 6, worksheet["C7:F7"]);

// Display a column sparkline in the total cell.
SparklineGroup totalGroup = worksheet.SparklineGroups.Add(worksheet["G8"], worksheet["C8:F8"], SparklineGroupType.Column);

To change the location of a single sparkline in a worksheet, use the Sparkline.SetPosition method. To modify a source data range for a sparkline, use the Sparkline.DataRange property.

See Also