Skip to main content

SparklineGroup object

Table of contents
  1. Remarks
  2. Example

Represents a group of sparklines.


The SparklineGroup object can contain multiple sparklines, and contains the property settings for the group, such as color and axis settings. Each sparkline is represented by a Sparkline object.

Use the Modify method to add or remove sparklines from the sparkline group. Use the ModifyLocation method to change the location of the sparkline, and use the ModifySourceData method to change the range of the source data.


The following code example creates a group of column sparklines at the location A1:A4 that are bound to the source data in the range Sheet2!B1:E4. The series color is changed to display the columns in red.

Dim mySG As SparklineGroup
Set mySG = Range("$A$1:$A$4").SparklineGroups.Add(Type:=xlSparkColumn, SourceData:="Sheet2!B1:E4")
mySG.SeriesColor.Color = RGB(255, 0, 0)

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>