SparklineGroup Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Represents a group of sparklines.

public interface class SparklineGroup : System::Collections::IEnumerable

[System.Runtime.InteropServices.Guid("000244B7-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface SparklineGroup : System.Collections.IEnumerable

Public Interface SparklineGroup
Implements IEnumerable

Attributes

GuidAttribute InterfaceTypeAttribute

Implements

IEnumerable

Remarks

The SparklineGroup object can contain multiple sparklines and contains the property settings for the group, such as color and axis settings. Each sparkline is represented by a Sparkline object.

Use the Modify(Range, String) method to add or remove sparklines from the sparkline group. Use the ModifyLocation(Range) method to change the location of the sparkline and use the ModifySourceData(String) method to change the range of the source data.

Properties

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[Object]	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.

Methods

Delete()	Deletes the sparkline group.
GetEnumerator()
Modify(Range, String)	Sets the location and the source data for the sparkline group.
ModifyDateRange(String)	Sets the date range for the sparkline group.
ModifyLocation(Range)	Sets the associated Range object to modify the location of the sparkline group.
ModifySourceData(String)	Sets the range that represents the source data for the sparkline group.