For a list of all members of this type, see ExcelSparklineSetting members.
Public Properties
| Name | Description | |
|---|---|---|
 | AxisColor | Gets or sets the color of the axis. |
| DisplayEmptyCellsAs | Gets or sets what to display empty cells as. |
| DisplayHidden | Gets or sets a value that indicates whether data in hidden cells is plotted for the sparklines in this sparkline group. |
| DisplayXAxis | Gets or sets a value that indicates whether the horizontal axis is displayed for each sparkline in this sparkline group. |
| FirstMarkerColor | Gets or sets the color of the first data point for each sparkline in this sparkline group. |
| Formula | Gets or sets a value that specifies the date range for the sparkline group. |
| HighMarkerColor | Gets or sets the color of the highest data point for each sparkline in this sparkline group. |
| LastMarkerColor | Gets or sets the color of the last data point for each sparkline in this sparkline group. |
| LineWeight | Gets or sets a value that specifies the line weight for each sparkline in the sparkline group, where the line weight is measured in points. The weight must be greater than or equal to zero, and must be less than or equal to 3 (LineSeries only supports a line weight value in the range of 0.0->3.0). |
| LowMarkerColor | Gets or sets the color of the lowest data point for each sparkline in this sparkline group. |
| ManualMax | Gets or sets a value that specifies the maximum for the vertical axis that is shared across all sparklines in this sparkline group. The value must be zero if maxAxisType does not equal custom. |
| ManualMin | Gets or sets a value that specifies the minimum for the vertical axis that is shared across all sparklines in this sparkline group. The value must be zero if minAxisType does not equal custom. |
| MarkersColor | Gets or sets a value that specifies the color of the data markers for each sparkline in this sparkline group. |
| MaxAxisType | Gets or sets a value that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated. |
| MinAxisType | Gets or sets a value that specifies how the vertical axis minimums for the sparklines in this sparkline group are calculated. |
| NegativeColor | Gets or sets a value that specifies the color of the negative data points for each sparkline in this sparkline group. |
| ReferenceError | Gets a value that indicates whether the current cell range is an invalid reference. |
| RightToLeft | Gets or sets a value that specifies whether each sparkline in the sparkline group is displayed in a right-to-left manner. |
| SeriesColor | Gets or sets a value that specifies the color for each sparkline in this sparkline group. |
| ShowFirst | Gets or sets a value that indicates whether the first data point is formatted differently for each sparkline in this sparkline group. |
| ShowHigh | Gets or sets a value that specifies whether the data points with the highest value are formatted differently for each sparkline in this sparkline group. |
| ShowLast | Gets or sets a value that indicates whether the last data point is formatted differently for each sparkline in this sparkline group. |
| ShowLow | Gets or sets a value that specifies whether the data points with the lowest value are formatted differently for each sparkline in this sparkline group. |
| ShowMarkers | Gets or sets a value that specifies whether data markers are displayed for each sparkline in this sparkline group. |
| ShowNegative | Gets or sets a value that specifies whether the negative data points are formatted differently for each sparkline in this sparkline group. |
See Also