XlSparklineGroup Properties
A sparkline group in a worksheet.
Name | Description |
---|---|
Color |
Gets or sets the color of the horizontal axis. |
Color |
Gets or sets the color of the first data point for each sparkline in the sparkline group. |
Color |
Gets or sets the color of the highest data point for each sparkline in the sparkline group. |
Color |
Gets or sets the color of the last data point for each sparkline in the sparkline group. |
Color |
Gets or sets the color of the lowest data point for each sparkline in the sparkline group. |
Color |
Gets or sets the color of the data markers for each sparkline in the sparkline group. |
Color |
Gets or sets the color of the negative data points for each sparkline in the sparkline group. |
Color |
Gets or sets the color for each sparkline in the sparkline group. |
Date |
Gets or sets the date range for the sparkline group. |
Display |
Gets or sets how empty cells are plotted. |
Display |
Gets or sets whether data in hidden cells are plotted in the sparkline group. |
Display |
Gets or sets whether data markers are displayed for each sparkline in the sparkline group. |
Display |
Gets or sets whether the horizontal axis is displayed for each sparkline in the sparkline group. |
Highlight |
Gets or sets whether the first data point in the sparkline should be colored differently. |
Highlight |
Gets or sets whether the highest data point in the sparkline should be colored differently. |
Highlight |
Gets or sets whether the last data point in the sparkline should be colored differently. |
Highlight |
Gets or sets whether the lowest data point in the sparkline should be colored differently. |
Highlight |
Gets or sets whether negative data points in the sparkline should be colored differently. |
Line |
Gets or sets the line weight for each sparkline in the sparkline group. |
Manual |
Gets or sets the maximum for the vertical axis that is the same for all sparklines in the sparkline group. |
Manual |
Gets or sets the minimum for the vertical axis that is the same for all sparklines in the sparkline group. |
Max |
Specifies how the vertical axis maximums for the sparklines in the sparkline group are calculated. |
Min |
Specifies how the vertical axis minimums for the sparklines in the sparkline group are calculated. |
Right |
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. |
Sparkline |
Gets or sets the type of a sparkline group. |
See Also