SparklineGroup.Type (Excel)

Gets or sets the type of sparkline for the group. Possible return values are xlSparkColumn - A column chart sparkline, xlSparkColumnStacked100 - A win/loss chart sparkline, xlSparkLine - A line chart sparkline.

ActiveCell.SparklineGroups(1).Type = xlSparkColumn