Share via


SparklineGroup.Modify Method (Excel)

Sets the location and the source data for the sparkline group.

Version Information

Version Added: Excel 2010

Syntax

expression .Modify(Location, SourceData)

expression A variable that represents a SparklineGroup object.

Parameters

Name

Required/Optional

Data Type

Description

Location

Required

Range

The Range object that represents the location of the sparkline group.

SourceData

Required

String

The range that represents the source data for the sparkline group.

Return Value

Nothing

Example

This examples selects a sparkline group in the location A1:A4 and removes a row of data by changing the sparkline group location to equal A1:A3. The data source must also be modified to only include the first three rows of data.

Range("A1:A4").Select 
ActiveCell.SparklineGroups.Item(1).Modify Location:=Range("$A$1:$A$3"), SourceData:="Sheet1!B1:D3"

See Also

Concepts

SparklineGroup Object Members

SparklineGroup Object