SparklineGroups Object (Excel)
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

SparklineGroups Object (Excel)

Represents a collection of sparkline groups.

Version Added: Excel 2010

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.

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