ExcelSparklineGroup Class |
Represents a group of sparklines: small charts drawn in cells, one for each row or column of a data range,
that share the same type, colors and markers. Create it with
Add(ExcelSparklineType, ExcelRange, ExcelRange)
of
SparklineGroups. Sparklines are available only in the Excel 2007+ (.xlsx)
format and are displayed by Excel 2010 and later.
Inheritance HierarchySystemObject
ExpertXls.ExcelLibExcelSparklineGroup
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic class ExcelSparklineGroup
Public Class ExcelSparklineGroup
The ExcelSparklineGroup type exposes the following members.
Properties| | Name | Description |
|---|
 | AxisColor |
Gets or sets the color of the horizontal axis, used when ShowAxis is true. Setting the color also sets ShowAxis to true.
|
 | Count |
Gets the number of sparklines of the group (one for each cell of the location range).
|
 | FirstPointColor |
Gets or sets the color of the first point, used when ShowFirstPoint is true. Setting the color also sets ShowFirstPoint to true.
|
 | HighPointColor |
Gets or sets the color of the highest point, used when ShowHighPoint is true. Setting the color also sets ShowHighPoint to true.
|
 | LastPointColor |
Gets or sets the color of the last point, used when ShowLastPoint is true. Setting the color also sets ShowLastPoint to true.
|
 | LineWeight |
Gets or sets the weight of the line sparklines, in points. The default value is 0.75.
|
 | LowPointColor |
Gets or sets the color of the lowest point, used when ShowLowPoint is true. Setting the color also sets ShowLowPoint to true.
|
 | MarkersColor |
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.
|
 | NegativePointsColor |
Gets or sets the color of the negative points, used when ShowNegativePoints is true. Setting the color also sets ShowNegativePoints to true.
|
 | SeriesColor |
Gets or sets the color of the lines or columns.
|
 | ShowAxis |
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.
|
 | ShowFirstPoint |
Gets or sets a value indicating if the first point is highlighted. The default value is false.
|
 | ShowHighPoint |
Gets or sets a value indicating if the highest point is highlighted. The default value is false.
|
 | ShowLastPoint |
Gets or sets a value indicating if the last point is highlighted. The default value is false.
|
 | ShowLowPoint |
Gets or sets a value indicating if the lowest point is highlighted. The default value is false.
|
 | ShowMarkers |
Gets or sets a value indicating if the line sparklines show a marker for each point. The default value is false.
|
 | ShowNegativePoints |
Gets or sets a value indicating if the negative points are highlighted. The default value is false.
|
 | Type |
Gets or sets the type of the sparklines: line, column or win/loss.
|
Top
See Also