Series.PictureType (Excel)

Returns or sets an XlChartPictureType value that represents the way pictures are displayed on a column or bar picture chart. Possible return values are xlStack - Picture is sized to repeat a maximum of 15 times in the longest stacked bar, xlStackScale - Picture is sized to a specified number of units and repeated the length of the bar, xlStretch - Picture is stretched the full length of the stacked bar.

ActiveChart.FullSeriesCollection(1).PictureType = xlStack