Skip to main content

XlSparklineGroup Members

A sparkline group in a worksheet.

Constructors

Name Description
XlSparklineGroup() Initializes a new instance of the XlSparklineGroup class with the default settings.
XlSparklineGroup(XlCellRange, XlCellRange) Creates a line sparkline group for the specified data and location.

Properties

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.

Methods

Name Description
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also