Share via


SparklineGroup.ModifySourceData Method (Excel)

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

Version Information

Version Added: Excel 2010

Syntax

expression .ModifySourceData(SourceData)

expression A variable that represents a SparklineGroup object.

Parameters

Name

Required/Optional

Data Type

Description

SourceData

Required

String

The range that represents the source data.

Return Value

Nothing

Example

This example selects a sparkline group in the location A1:A4 and modifies the source data to include an additional column using the data in the range B1:D4.

Range("A1:A4").Select 
ActiveCell.SparklineGroups.Item(1).ModifySourceData "B1:D4"

See Also

Concepts

SparklineGroup Object

SparklineGroup Object Members