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"