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