SparklineGroup Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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 associated SparkPoints object for the sparkline group. Read-only.

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.

Show: