SparklineGroups.Add method (Excel)

Creates a new sparkline group and returns a SparklineGroup object.

Syntax

expression.Add (Type, SourceData)

expression A variable that represents a SparklineGroups object.

Parameters

Name	Required/Optional	Data type	Description
Type	Required	XlSparkType	The type of sparkline.
SourceData	Required	String	Represents the range to use to create the sparkline.

Return value

SparklineGroup

Example

This example adds a sparkline group to the range A1:A4. The sparklines in the group are column sparklines and are bound to the data in the range B1:E4.

Range("$A$1:$A$4").SparklineGroups.Add Type:=xlSparkColumn, SourceData:= _ 
 "Sheet2!B1:E4"

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.