SparklineGroup object (Excel)

Represents a group of sparklines.


The SparklineGroup object can contain multiple sparklines, and contains the property settings for the group, such as color and axis settings. Each sparkline is represented by a Sparkline object.

Use the Modify method to add or remove sparklines from the sparkline group. Use the ModifyLocation method to change the location of the sparkline, and use the ModifySourceData method to change the range of the source data.


Application.ReferenceStyle must be set to xlA1 to execute SparklineGroups.Add.


The following code example creates a group of column sparklines at the location A1:A4 that are bound to the source data in the range Sheet2!B1:E4. The series color is changed to display the columns in red.

Dim mySG As SparklineGroup 
Set mySG = Range("$A$1:$A$4").SparklineGroups.Add(Type:=xlSparkColumn, SourceData:= _ 
mySG.SeriesColor.Color = RGB(255, 0, 0)



See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.