Share via

SparklineGroup Members (Excel)

  • Article

Represents a group of sparklines.

Methods

Name

Description

Delete

Deletes the sparkline group.

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.

Properties

Name

Description

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. Read-only.

Axes

Returns the associated SparkAxes object. Read-only.

Count

Returns the number of sparklines in the sparkline group. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

DateRange

Gets or sets the date range for the sparkline group. Read/write.

DisplayBlanksAs

Returns or sets the way that blank cells are plotted on a chart. Can be one of the XlDisplayBlanksAs constants. Read/write Long.

DisplayHidden

Specifies if hidden cells are plotted in the sparkline group. Read/write.

Item

Returns a Sparkline object. Read-only

LineWeight

Gets or sets the thickness of the sparklines in the sparkline group. Read/write.

Location

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

Parent

Returns the parent object for the specified object. Read-only.

PlotBy

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

Points

Returns the position of the specified node as a coordinate pair. Each coordinate is expressed in points. Read-only Variant.

SeriesColor

Returns a FormatColor object that represents the main series color for the sparkline group. Read-only.

SourceData

Returns or sets the range that contains the source data for the sparkline group. Read/write.

Type

Gets or sets the type of sparkline for the group. Read/write.