XlSparklineGroup.HighlightNegative Property

Gets or sets whether negative data points in the sparkline should be colored differently.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public bool HighlightNegative { get; set; }

VB.NET

Public Property HighlightNegative As Boolean

Property Value

Type	Description
Boolean	True to highlight negative data points; otherwise, false.

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, 8, 6), XlCellRange.FromLTRB(9, 1, 9, 6));
// Change the sparkline group type to "Column".
group.SparklineType = XlSparklineType.Column;
// Set the series color.
group.ColorSeries = XlColor.FromTheme(XlThemeColor.Accent1, 0.0);
// Set the color for negative points on sparklines. 
group.ColorNegative = XlColor.FromTheme(XlThemeColor.Accent2, 0.0);
// Set the color for the highest points on sparklines.
group.ColorHigh = XlColor.FromTheme(XlThemeColor.Accent6, 0.0);
// Highlight the highest and negative points on each sparkline in the group.
group.HighlightNegative = true;
group.HighlightHighest = true;
sheet.SparklineGroups.Add(group);

SparklineActions.vb

' Create a sparkline group.                   
Dim group As New XlSparklineGroup(XlCellRange.FromLTRB(1, 1, 8, 6), XlCellRange.FromLTRB(9, 1, 9, 6))
' Change the sparkline group type to "Column".
group.SparklineType = XlSparklineType.Column
' Set the series color.
group.ColorSeries = XlColor.FromTheme(XlThemeColor.Accent1, 0.0)
' Set the color for negative points on sparklines. 
group.ColorNegative = XlColor.FromTheme(XlThemeColor.Accent2, 0.0)
' Set the color for the highest points on sparklines.
group.ColorHigh = XlColor.FromTheme(XlThemeColor.Accent6, 0.0)
' Highlight the highest and negative points on each sparkline in the group.
group.HighlightNegative = True
group.HighlightHighest = True
sheet.SparklineGroups.Add(group)