SparklineGroup.ModifySourceData Method (Excel)

Published: July 16, 2012

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

Version Added: Excel 2010

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

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"

Community Additions

ADD
Show:
© 2014 Microsoft