But I think your example is to change the format of a shape but not within a graph.
May be I need to explain a bit better what are the options I like to access thru vba.
When you right click on a column of a chart then select "Format Data Point" then select "Fill" then select "Picture or Texture fill" you have a section call "Stretch Options - Offsets" where you can enter % for left, right top and bottom. I would like to know the vba code to change these percentages.
I cannot make your code so that it change the column width.
The graph I have the columns amount represent the profit and I am using the offset left and right % to set the column's width based on the volume of sales.
I know how to do this manually but I like to write a macro to have it automated. With the code you provided the coloum width is not changing. I have played with the value for the textureOffsetX, .TextureOffsetY, TextureHorizontalScale and TextureVerticalScale but still the column width stay unchanged.