SparklineGroup SparklineGroup SparklineGroup Interface

Definition

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
Implements

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 Application 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 Axes Axes

Gets the associated SparkAxes object.

Count Count Count

Gets the number of sparklines in the sparkline group.

Creator Creator Creator

Gets a 32-bit integer that indicates the application in which this object was created.

DateRange DateRange DateRange

Gets or sets the date range for the sparkline group.

DisplayBlanksAs DisplayBlanksAs DisplayBlanksAs

Gets or sets the way that blank cells are plotted on a chart.

DisplayHidden DisplayHidden DisplayHidden

Specifies whether hidden cells are plotted in the sparkline group.

Item[Object] Item[Object] Item[Object]

Returns a Sparkline object.

LineWeight LineWeight LineWeight

Gets or sets the thickness of the sparklines in the sparkline group.

Location Location Location

Gets or sets the Range object that represents the location of the sparkline group.

Parent Parent Parent

Gets the parent object for the specified object.

PlotBy PlotBy PlotBy

Gets or sets how to plot the sparkline when the data on which it is based is in a square-shaped range.

Points Points Points

Gets the position of the specified node as a coordinate pair. Each coordinate is expressed in points.

SeriesColor SeriesColor SeriesColor

Gets a FormatColor object that represents the main series color for the sparkline group.

SourceData SourceData SourceData

Gets or sets the range that contains the source data for the sparkline group.

Type Type Type

Gets or sets the type of sparkline for the group.

Methods

Delete() Delete() Delete()

Deletes the sparkline group.

GetEnumerator() GetEnumerator() GetEnumerator()
Modify(Range, String) Modify(Range, String) Modify(Range, String)

Sets the location and the source data for the sparkline group.

ModifyDateRange(String) ModifyDateRange(String) ModifyDateRange(String)

Sets the date range for the sparkline group.

ModifyLocation(Range) ModifyLocation(Range) ModifyLocation(Range)

Sets the associated Range object to modify the location of the sparkline group.

ModifySourceData(String) ModifySourceData(String) ModifySourceData(String)

Sets the range that represents the source data for the sparkline group.

Applies to