SparklineGroups Object
TOC
Collapse the table of content
Expand the table of content

SparklineGroups Object (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

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

Represents a collection of sparkline groups.

The SparklineGroups object can contain multiple SparklineGroup objects.

Use the SparklineGroups property of the Range object to return an existing SparklineGroups collection from its parent range.

Use the Add method to create a group of new sparklines.

Use the Group method to create a group of existing sparklines.

This example selects the range A1:A4 and groups the sparklines in that range. If the sparklines in the sparkline group are line sparklines, the markers are displayed in red.

Range("A1:A4").Select 
Selection.SparklineGroups.Group Location := Range("A1") 
Selection.SparklineGroups.Item(1).Points.Markers.Visible = True 
Selection.SparklineGroups.Item(1).Points.Markers.Color.Color = 255
Show:
© 2016 Microsoft