Sparkline Object (Excel)

Use the ModifyLocation method to change the location of a single sparkline, and use the ModifySourceData method to change the range of the source data.
To work with a group of sparklines at once, use the members of the SparklineGroup object.