SparklineGroup Members
Include Protected Members
Include Inherited Members
Represents a group of sparklines.
The SparklineGroup type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
Application | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. |
|
Axes | Gets the associated SparkAxes object. |
|
Count | Gets the number of sparklines in the sparkline group. |
|
Creator | Gets a 32-bit integer that indicates the application in which this object was created. |
|
DateRange | Gets or sets the date range for the sparkline group. |
|
DisplayBlanksAs | Gets or sets the way that blank cells are plotted on a chart. |
|
DisplayHidden | Specifies whether hidden cells are plotted in the sparkline group. |
|
Item | Returns a Sparkline object. |
|
LineWeight | Gets or sets the thickness of the sparklines in the sparkline group. |
|
Location | Gets or sets the Range object that represents the location of the sparkline group. |
|
Parent | Gets the parent object for the specified object. |
|
PlotBy | Gets or sets how to plot the sparkline when the data on which it is based is in a square-shaped range. |
|
Points | Gets the position of the specified node as a coordinate pair. Each coordinate is expressed in points. |
|
SeriesColor | Gets a FormatColor object that represents the main series color for the sparkline group. |
|
SourceData | Gets or sets the range that contains the source data for the sparkline group. |
|
Type | Gets or sets the type of sparkline for the group. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
Delete | Deletes the sparkline group. |
|
GetEnumerator() | (Inherited from IEnumerable.) |
|
GetEnumerator() | |
|
Modify | Sets the location and the source data for the sparkline group. |
|
ModifyDateRange | Sets the date range for the sparkline group. |
|
ModifyLocation | Sets the associated Range object to modify the location of the sparkline group. |
|
ModifySourceData | Sets the range that represents the source data for the sparkline group. |
Top