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