Skip to content

Latest commit

 

History

History
50 lines (30 loc) · 1.16 KB

Excel.SparklineGroups.Add.md

File metadata and controls

50 lines (30 loc) · 1.16 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
SparklineGroups.Add method (Excel)
vbaxl10.chm869073
vbaxl10.chm869073
Excel.SparklineGroups.Add
ae41a572-c073-5251-b2c1-884e832e8ae5
05/16/2019
medium

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"

[!includeSupport and feedback]