Skip to main content

XlSparklineGroup Properties

A sparkline group in a worksheet.
Name Description
ColorAxis Gets or sets the color of the horizontal axis.
ColorFirst Gets or sets the color of the first data point for each sparkline in the sparkline group.
ColorHigh Gets or sets the color of the highest data point for each sparkline in the sparkline group.
ColorLast Gets or sets the color of the last data point for each sparkline in the sparkline group.
ColorLow Gets or sets the color of the lowest data point for each sparkline in the sparkline group.
ColorMarker Gets or sets the color of the data markers for each sparkline in the sparkline group.
ColorNegative Gets or sets the color of the negative data points for each sparkline in the sparkline group.
ColorSeries Gets or sets the color for each sparkline in the sparkline group.
DateRange Gets or sets the date range for the sparkline group.
DisplayBlanksAs Gets or sets how empty cells are plotted.
DisplayHidden Gets or sets whether data in hidden cells are plotted in the sparkline group.
DisplayMarkers Gets or sets whether data markers are displayed for each sparkline in the sparkline group.
DisplayXAxis Gets or sets whether the horizontal axis is displayed for each sparkline in the sparkline group.
HighlightFirst Gets or sets whether the first data point in the sparkline should be colored differently.
HighlightHighest Gets or sets whether the highest data point in the sparkline should be colored differently.
HighlightLast Gets or sets whether the last data point in the sparkline should be colored differently.
HighlightLowest Gets or sets whether the lowest data point in the sparkline should be colored differently.
HighlightNegative Gets or sets whether negative data points in the sparkline should be colored differently.
LineWeight Gets or sets the line weight for each sparkline in the sparkline group.
ManualMax Gets or sets the maximum for the vertical axis that is the same for all sparklines in the sparkline group.
ManualMin Gets or sets the minimum for the vertical axis that is the same for all sparklines in the sparkline group.
MaxScaling Specifies how the vertical axis maximums for the sparklines in the sparkline group are calculated.
MinScaling Specifies how the vertical axis minimums for the sparklines in the sparkline group are calculated.
RightToLeft Gets or sets whether the data points on the horizontal axis are plotted in right-to-left order.
Sparklines Provides access to the collection of sparklines contained in the sparkline group.
SparklineType Gets or sets the type of a sparkline group.
See Also