How to: Customize the Sparkline Appearance

• Oct 29, 2020
• 3 minutes to read

This topic demonstrates how to adjust the sparkline appearance.

• Specify a sparkline color

  To specify a color used to draw each sparkline in the sparkline group, use the SparklineGroup.SeriesColor property. For a group of line sparklines, you can also set the line weight by utilizing the SparklineGroup.LineWeight property.

• Highlight data points

  You can highlight important data points on a sparkline by displaying and coloring markers on line sparklines, or by differentiating points by color on column and win/loss sparklines. To get access to the marker options, use the SparklineGroup.Points property, which returns the SparklinePoints object. The table below lists the object’s properties used to show specific points on each sparkline in the sparkline group. All these properties return the SparklineColor object which controls the visibility and color of data markers.

  Thus, to display the desired marker on a line sparkline, use the corresponding property to get access to the SparklineColor object, and set the SparklineColor.IsVisible property to true. In case of column and win/loss sparklines (which display all data markers by default), setting the SparklineColor.IsVisible property highlights the proper sparkline bars using the color defined by the applied sparkline style. To apply a custom color to the marker, assign the desired color to the SparklineColor.Color property.

  Property	Description
  SparklinePoints.Markers	Displays all markers on a line sparkline to differentiate individual data points.
  SparklinePoints.Negative	Highlights markers that correspond to all data values less than zero.
  SparklinePoints.Highest	Highlights a marker that corresponds to the highest data value.
  SparklinePoints.Lowest	Highlights a marker that corresponds to the lowest data value.
  SparklinePoints.First	Highlights a marker that corresponds to the first data point.
  SparklinePoints.Last	Highlights a marker that corresponds to the last data point.

C#

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

VB.NET

' Create a group of line sparklines.
Dim lineGroup As SparklineGroup = 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(&H1F, &H49, &H7D)

' Set the sparkline weight.
lineGroup.LineWeight = 1.5

' Display data markers on the sparklines and specify their color.
Dim points As SparklinePoints = lineGroup.Points
points.Markers.IsVisible = True
points.Markers.Color = Color.FromArgb(&H4B, &HAC, &HC6)

' Highlight the highest and lowest points on each sparkline in the group.
points.Highest.Color = Color.FromArgb(&HA9, &HD6, &H4F)
points.Lowest.Color = Color.FromArgb(&H80, &H64, &HA2)

The following image shows sparkline charts created by the code above.