Excel.SparklineGroups.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
SparklineGroups object (Excel)	vbaxl10.chm868072	vbaxl10.chm868072	Excel.SparklineGroups	9bc6be34-fa2e-8652-ca92-fa9630b4d7a6	04/02/2019	medium

SparklineGroups object (Excel)

Represents a collection of sparkline groups.

Remarks

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.

Example

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

Methods

• Add
• Clear
• ClearGroups
• Group
• Ungroup

Properties

• Application
• Count
• Creator
• Item
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]