Click or drag to resize

ExcelSparklineGroup Properties

The ExcelSparklineGroup type exposes the following members.

Properties
 NameDescription
Public propertyAxisColor Gets or sets the color of the horizontal axis, used when ShowAxis is true. Setting the color also sets ShowAxis to true.
Public propertyCount Gets the number of sparklines of the group (one for each cell of the location range).
Public propertyFirstPointColor Gets or sets the color of the first point, used when ShowFirstPoint is true. Setting the color also sets ShowFirstPoint to true.
Public propertyHighPointColor Gets or sets the color of the highest point, used when ShowHighPoint is true. Setting the color also sets ShowHighPoint to true.
Public propertyLastPointColor Gets or sets the color of the last point, used when ShowLastPoint is true. Setting the color also sets ShowLastPoint to true.
Public propertyLineWeight Gets or sets the weight of the line sparklines, in points. The default value is 0.75.
Public propertyLowPointColor Gets or sets the color of the lowest point, used when ShowLowPoint is true. Setting the color also sets ShowLowPoint to true.
Public propertyMarkersColor Gets or sets the color of the markers of the line sparklines, used when ShowMarkers is true. Setting the color also sets ShowMarkers to true. It can be set only for a group of line sparklines.
Public propertyNegativePointsColor Gets or sets the color of the negative points, used when ShowNegativePoints is true. Setting the color also sets ShowNegativePoints to true.
Public propertySeriesColor Gets or sets the color of the lines or columns.
Public propertyShowAxis Gets or sets a value indicating if the horizontal axis is shown when the data has positive and negative values. The default value is false.
Public propertyShowFirstPoint Gets or sets a value indicating if the first point is highlighted. The default value is false.
Public propertyShowHighPoint Gets or sets a value indicating if the highest point is highlighted. The default value is false.
Public propertyShowLastPoint Gets or sets a value indicating if the last point is highlighted. The default value is false.
Public propertyShowLowPoint Gets or sets a value indicating if the lowest point is highlighted. The default value is false.
Public propertyShowMarkers Gets or sets a value indicating if the line sparklines show a marker for each point. The default value is false.
Public propertyShowNegativePoints Gets or sets a value indicating if the negative points are highlighted. The default value is false.
Public propertyType Gets or sets the type of the sparklines: line, column or win/loss.
Top
See Also