| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
SparklineGroup.Modify method (Excel) |
vbaxl10.chm871081 |
|
|
596cdecb-dd03-0a63-e2b8-9aa459ff719c |
05/16/2019 |
medium |
Sets the location and the source data for the sparkline group.
expression.Modify (Location, SourceData)
expression A variable that represents a SparklineGroup object.
| 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. |
Nothing
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"[!includeSupport and feedback]