Class SparklineGroup (Excel VBA)

The class SparklineGroup represents a group of sparklines.

The classes SparkAxes, Sparkline and SparkPoints. give access to class SparklineGroup


Dim sprlng as SparklineGroup
Set sprlng = ActiveCell.SparklineGroups(Index:=1)

For Each

Here is an example of processing the SparklineGroup items in a collection. 


Dim sprlng As SparklineGroup
For Each sprlng In ActiveCell.SparklineGroups
	
Next sprlng

Methods

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

Axes returns the associated SparkAxes object.

Count returns the number of sparklines in the sparkline group.

DateRange gets or sets the date range for the sparkline group.

DisplayBlanksAs expression.DisplayBlanksAs

DisplayHidden specifies if 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. Read/write.

Location

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

Points returns the associated SparkPoints object for the sparkline group.

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

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

Type gets or sets the type of sparkline for the group.

FormatColor - Represents the fill color specified for a threshold of a color scale conditional format or the color of the bar in a data bar conditional format.

Range - Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3D range.

SparkAxes - Represents the settings for the horizontal and vertical axes of a group of sparklines.

Sparkline - Represents a single sparkline.

SparkPoints - Represents the settings of the markers for points of data on a sparkline.